•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)
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]
Want to read more?
Check out the full article on the original site
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