conditional format a cell based on the value of a second cell

[peter terry]

Is it possible to make the conditional format of a cell dependant on the
value of a different cell?

I would like to have the text in cell A2 change colour if cell B2 has a
value of zero, but there doesn't appear to be an option to "target" a
different cell.


TIA

pete

 

[RagDyeR]

You have to expand the left box and choose "Formula Is".
Then enter this formula:
=B2=0

This does however, make A2 display Red even when B2 is empty.

If you want A2 to be Red *only* when B2 is zero, use this formula:
=AND(B2=0,B2<>"")
--


HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is it possible to make the conditional format of a cell dependant on the
value of a different cell?

I would like to have the text in cell A2 change colour if cell B2 has a
value of zero, but there doesn't appear to be an option to "target" a
different cell.


TIA

pete

 

[peter terry]

Superb! Ta very much