IF

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

Guest

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
 
thx valco,
really appreciate ur help. what if the cell colour to be formatted (a1 in ur
ex) is text dependent?
 
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)
 
Back
Top