conditional formatting with formula

M

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
 
B

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
 
Top