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

How to apply conditional formatting to multiple columns based off of data in one column

Hello, 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]

Want to read more?

Check out the full article on the original site

View original article