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.

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.

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.

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.