Conditional Formatting

[Edward]

I using Excel 2007 in Vista.

I have two adjacent cells, say A1 and A2.

I want the text in A2 to change to red if its value exceeds the value in A1.

I have tried Conditional Formatting but while it looks okay it does not
work.

TIA for any help.

Ed

 

[John]

Hi Edward
Goto Format>Conditional Formatting> "Change cell value is" to Formula and type
this in =B1>A1 then set color, it should work
HTH
John

 

[Edward]

Thanks a million, John. Worked fine, with a little tweak (my fault).

Ed

 

[John]

Anytime Edward, you're welcome
John

Thanks a million, John. Worked fine, with a little tweak (my fault).

Ed