Comparison result changes font color

[GScott]

I want to compare 2 cells. If cell a1 is less than cell a2, then I want cell
a1 to be red. How do I do that?
Thanks.

 

[GScott]

I found it: Conditional Formatting

 

[SteveG]

Use Conditional Formatting.

Select cell A1. Go to Format Menu>Conditional Formatting. Condition
should be:

Box 1, Cell Value is: box 2, less than box 3, A2

Click on Format, Patterns Tab. Select the color you want to have A
fill if the condition is true. Click OK, OK.

HTH

Stev