conditional formatting with formula

[mwc0914]

I can't get this to work...I want to format the contents in cell A
based upon the value of cell B1.

I open the conditional formatting...I select "Formula is"...I ente
=if(b1=0)...I select my formatting options.

I enter 0 in cell B1 and the formatting in cell A1 does not occur.
must be formatting my formula wrong. Even if I format my formula a bi
wrong, Excel corrects it, but even then, the formatting in cell A1 i
not occuring

 

[Biff]

Hi!

Since an empty cell evaluates to 0, if B1 is empty it will equal zero and
the cf will be applied.

Try one of these as the cf formula:

=AND(ISNUMBER(B1),B1=0)

Or

=AND(B1<>"",B1=0)

Biff