IF

M

Malik

I hve a formula in a cell. Is it possible that I format the cell in such a
way that if the value comes to >5, the background color changes automatically?

Thanks
 
M

Malik

thx valco,
really appreciate ur help. what if the cell colour to be formatted (a1 in ur
ex) is text dependent?
 
T

T. Valko

Then you use a different formula.

=A1="text"

Where "text" is the string you want to test for. For example:

=A1="apples"

Or, if you want to compare 2 cells:

B1 = apples

Then:

=AND(A1<>"",B1<>"",A1=B1)
 
Top