Excel 2007 : Result fixes cell color.

[pawnraider]

Cell 1 and cell 2 are sums. If cell 2 is larger than cell 1 I would like it to become a specific color? And is it possible to have only the number change color instead the cell? Thanks for the help.

Frank

[Paul]

Hi Frank,

You can use Conditional Formatting for this. Select cell 2 then on the Home ribbon tab click Conditional Formatting. Then select 'Highlight Cell Rules' then 'Greater than...'.

In the Greater Than dialog, click the little arrow to the left of the word "with" and select cell 1. Then in the drop-down box pick a format or select Custom Format and set your own.

Hope that helps!