condition formating
 

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?

condition formating
 

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

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

Hope this helps.

Pete

condition formating
 

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