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.