Forum Discussion
mrschristie
Feb 02, 2025Copper Contributor
How do I format a cell to turn red if any cells in a column are red.
I have a sheet showing a variety of variables based on addition of different numbers in columns.
I am looking to format a cell to turn red if any cells in a specific column are red. This way it will automatically tell me what different options will and won't work.
Example:
I would want the cell where it shows AFA/ AFB/ AFC... to turn red if any of the cells in the column with these combinations are red as shown below.
Not sure if this is even possible but I'm stumped as to what formula to write in the top cell!
- m_tarlerBronze Contributor
conditional formatting can not look at the color of cells. Assuming the red in that column is already based on a conditional formatting rule, you can do a custom formula to combine rules in that column. I don't understand what you want to turn red nor the rules already present so more details or sample sheet is needed to suggest specific rules. Just an FYI, you can use * as an AND and + as an OR so =(cond 1)*(cond 2) + (cond 3) would be true for "Cond 1" AND "Cond 2" OR "Cond 3" being true.