1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

how to do conditional formatting by text in bulk?

i have a column with 7 categories, and i want to make each catagory its own color, for example if we have apples i want the whole row to be the red, i know i can do it one by one, but that would be a pain in the ass, is there an option that makes the conditions and i just pick the color for each?

submitted by /u/PurpleDurian7220
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#row zero
#financial modeling with spreadsheets
#Excel alternatives