condition formating

C

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?
 
P

Pete_UK

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

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

Hope this helps.

Pete
 
D

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
 
Top