How to set text color based on value in cell compared to constant
 

I would like to change the text color or cell color based on a comparison of
the cell value to a constant. The value in the cells are number inputs not
results of formulas.

How to set text color based on value in cell compared to constant
 

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

--
__________________________________
HTH

Bob

"Pishta V" <Pishta wrote in message
...
I would like to change the text color or cell color based on a comparison
of
the cell value to a constant. The value in the cells are number inputs
not
results of formulas.

How to set text color based on value in cell compared to constant
 

Use conditional formatting
Enter the value you want in the condition cell and format as you wish.

"Pishta V" wrote:

I would like to change the text color or cell color based on a comparison of
the cell value to a constant. The value in the cells are number inputs not
results of formulas.

How to set text color based on value in cell compared to constant
 

FormatConditional FormattingFormula is:

=A1<constant

constant can be hard entered or a cell reference like $D$1


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 13:34:07 -0700, Pishta V <Pishta
wrote:

I would like to change the text color or cell color based on a comparison of
the cell value to a constant. The value in the cells are number inputs not
results of formulas.