•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional conditional formatting (long/multiple conditions list)
Our take
Managing conditional formatting for extensive lists of text tags or names can be daunting, especially when dealing with 13 or 26 entries that may grow over time. Manually setting up and maintaining numerous formatting rules is inefficient and overwhelming. However, there are innovative, non-VBA solutions that can simplify this process. By leveraging advanced features in spreadsheet software, you can automatically create conditional formatting that visually highlights your lists without the need for extensive setup.
How do I automatically create conditional formatting for text tags/names for really long lists of tags/names? One list has 13 entries, the other has 26. Either of those numbers might grow, and already it would be a nightmare to setup and maintain the list of conditional formatting rules one by one. The combo of tags is currently at 312 (not all combos are meaningful). Conditional formatting for the combo list might be too much to aim for, but I would like at least a visual on the 13 and 26 lists tags without manually setting up and upkeeping 39 conditional formatting rules.
Would prefer non-VBA solution due to file permission (company) rules.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#Excel alternatives#conditional formatting#conditional formatting rules#tags#long lists#text tags#tags/names#multiple conditions#upkeep#combination of tags#combo list#automatically create#VBA solution#nightmare maintenance#manual setup