Conditional Cell Formatting

[Guest]

I am trying to point the conditions of 'conditional
formatting' to a formula in another cell. Is there an
easy way to do this?

 

[Ron Rosenfeld]

I am trying to point the conditions of 'conditional
formatting' to a formula in another cell. Is there an
easy way to do this?

Use that same formula in the Formula Is: option

Or use a formula of the type:

=Desired_Value = Another_Cell_ref

In other words, if you want to have C1 turn green if A1 = 23, Conditionally
Format C1 and use Formula Is: =A1=23


--ron

 

[Frank Kabel]

Hi
if you want to make for example cell A1 dependent from the result in
cell B1 try the following:
- select cell A1
- goto the conditional format dialog
- enter a formula such as:
=B1>0