Conditional Formatting

[Steve]

Using the wizard how would I get cell A3 to turn red if cell A1 is greater
than cell A2.

Thanks

Steve Hubbard

 

[jeff]

Hi,

click on "Formula is" rather than"Cell value" and
enter = =$A$2>$A$1

then set your formatting (Patterns) to red.

jeff

 

[Guest]

select "Formula is"
in formula block type =a1>a2Then select the format
button, select patterns and set color to be red.

 

[David McRitchie]

It is important to select the cell that is going to get the coloring.
My page on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm