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?
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?
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
In the Formula Is panel of the Conditional Format, enter this:
=AND(ISNUMBER(B2),B2<50)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks