Color change

[zeewaa]

I would like the color to change in a cell if the result is greater than
another cell.

What I have is a cell(D21) that has added up a column of estimated dollar
figures (=Sum(D520)). I than have a cell(E21) that add up a second column
of actual figures (=SUM(E5:E20)). what I want to do is to have cell E21 value
to show up in red if it is greater that cell D21.

 

[Ruth]

Make the E21 active - click on Format---- Conditional Formatting--
in the pop up box-- Choose ---Cell Value Is-- Greater than ---type in the
3rd box =$D$21... then click on Format -in the Font Tab choose red in the
color box- click OK than click ok in the Conditional Formatting Box