Excel 2003 cell result changes color

B

billz

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??
 
G

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
 
Top