Cell Coloring

[MrMarbles]

Cell A1 is red based on a conditional format I have set up. I want to do the
following: If cell A1 is red because of conditional format, then make cell
A2 red.

 

[David Biddulph]

Use "Formula Is", rather than "Cell Value Is" in your Conditional Formatting
condition, then set up an appropriate formula which looks at the value in
A1, so for example CF/ Formula Is/ =A1>500

 

[Bob Phillips]

Apply CF with the same conditions to A2.

HTH

Bob