Cell Coloring
 

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.

Cell Coloring
 

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/ =A1500
--
David Biddulph

MrMarbles wrote:
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.

Cell Coloring
 

Apply CF with the same conditions to A2.

HTH

Bob

"MrMarbles" wrote in message
...
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.