Conditional Formatting

  • Thread starter Thread starter Edward
  • Start date Start date
E

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