View Single Post
  #1   Report Post  
mwc0914
 
Posts: n/a
Default conditional formatting with formula


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

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

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


--
mwc0914
------------------------------------------------------------------------
mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130
View this thread: http://www.excelforum.com/showthread...hreadid=388691