Conditional Cell Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I am trying to point the conditions of 'conditional
formatting' to a formula in another cell. Is there an
easy way to do this?
Click to expand...

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
 
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
 
Back
Top