Excel 2003 cell result changes color

[Guest]

Is there anyway to have a result of a formula change the color of that cell?

Is there a way to compare two cells, then allow one of the cells to change
color if the differance is positive or negative??

 

[Guest]

Use Conditional Formatting
formula is

see:

http://www.contextures.com/xlCondFormat01.html

 

[Gord Dibben]

For first part.............select the cell to color

Format>Condtional Formatting

Cell value is: whatever Format to a pattern

For second part.........select A1 as an example

Format>CF>Condition1>Formula is: =A1>B1 Format to a pattern

Condition2>Formula is: =A1<B1 Format to a pattern

You may also want to look at Absolute and Relative cell referencing using $
signs.


Gord Dibben MS Excel MVP

 

[Guest]

The site you included did the trick. Thanks.

Use Conditional Formatting
formula is

see:

http://www.contextures.com/xlCondFormat01.html