With that cell active, use Home/Conditional Formatting, use new Rule, use
Use a formula to determine which cells to format and enter this formula:
=AND(A1<B1,B1<"")
then click format/fill/red
then do another New Rule and use
=AND(A1=B1,B1<"")
then click format/fill/green.

HTH
Bob Umlas
Excel MVP

"Nickle" wrote in message
...
I would like a Cell's Text to turn green if A1=B1, but turn red if A1<B1,
and no formatting if B1 is blank. What is the best way to go about this?
I
have excel2007.