condition formating

[chiuinggum]

i did a condition formating where by if B2 cell is smaller than 50 it will be
colored with red. However the B2 cell is 'defaulted' red even before I fill
up its value. It should not be color until B2 is fill up. How do I do it?

[Debra Dalgleish]

Select cell B2, and choose Format > Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =AND(B2<>"",B2<50)
Click the Format button, and on the Patterns tab, select Red
Click OK

chiuinggum wrote:
> i did a condition formating where by if B2 cell is smaller than 50 it will be
> colored with red. However the B2 cell is 'defaulted' red even before I fill
> up its value. It should not be color until B2 is fill up. How do I do it?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

[Pete_UK]

In the Formula Is panel of the Conditional Format, enter this:

=AND(ISNUMBER(B2),B2<50)

Hope this helps.

Pete