Tammy

What do you want if number is exactly 50 or 50000?

FormatConditional FormattingCell Value is: between 50(or 50.1) and 50000(or
49999.9) depending upon the answer to first question.


Gord Dibben MS Excel MVP


On Tue, 27 Feb 2007 12:23:06 -0800, Tammy
wrote:

Is there a way (macro or vb code) to make a text appear a certain color. For
example, if the number in the cells a1:aa65000 50 but <50000 then color them
red?