•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how to do conditional formatting by text in bulk?
Our take
Conditional formatting by text in bulk can significantly enhance your spreadsheet's visual appeal and clarity. If you have a column with multiple categories, such as "apples," and want to assign distinct colors to each category, you can streamline the process. Instead of formatting each row individually, you can set up rules that automatically apply colors based on the text in your chosen column. This method not only saves time but also ensures consistency across your data, making it easier to analyze at a glance.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to apply conditional formatting to multiple columns based off of data in one columnHello, I am working on a spreadsheet where I would like both columns B and C to change to the same color based on the information in column B, regarless of what it says in column C. For example, column B might read "Tan" and column C reads "Brick Yellow", but I want both cells to change to the formatting that I select for the word "Tan". Any help is appreciated! Thanks submitted by /u/Academic_Angle_6333 [link] [comments]
- Conditional formatting highlighted cellsHoping you can help me! Everyone at my office is a huge novice with Excel - I understand the basics but am not terribly great myself. We need one (hopefully) simple thing. Essentially, we have a dataset that we want to flag column A with a highlighted color if anything in that row is a color. Column A will always contain one of 5 words -- I've already done that with data validation. But what we want is, for instance, if I highlight cell H7 in yellow, it would then highlight A7 with the same color. I tried playing around with conditional formatting but I wasn't able to get it quite right. Thanks in advance for any assistance you can give! submitted by /u/THE_GREAT_PICKLE [link] [comments]