Excel 2003 cell result changes color
 

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

Excel 2003 cell result changes color
 

Use Conditional Formatting
formula is

see:

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

--
Gary's Student
gsnu200705


"billz" wrote:

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

Excel 2003 cell result changes color
 

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

FormatCondtional Formatting

Cell value is: whatever Format to a pattern

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

FormatCFCondition1Formula is: =A1B1 Format to a pattern

Condition2Formula 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

On Tue, 13 Feb 2007 16:51:03 -0800, billz wrote:

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

Excel 2003 cell result changes color
 

The site you included did the trick. Thanks.

"Gary''s Student" wrote:

Use Conditional Formatting
formula is

see:

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

--
Gary's Student
gsnu200705


"billz" wrote:

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