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

[Pishta V]

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.

 

[Bob Phillips]

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

 

[Sheeloo]

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

 

[Gord Dibben]

Format>Conditional Formatting>Formula 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