Excel IsBlank Opposite? 1

[Hakala]

Hi, Tek-tippers! I'm looking for the opposite to the =IF(ISBLANK(B1) Excel formula.... I want my conditional formatting to kick in if cell B1 is NOT blank.

I have no control over the value that will be put in cell B1; I just want to trigger a color change in another cell if B1 is full.

This is probably something way simple and I just can't seem to find it. Thanks!

Michelle Hakala

http://www.winebird.com/

 

[mintjulep]

=NOT(ISBLANK(B1))