Conditional Formatting based on another Cell

**Mondy** · 10-12-2009, 06:57 AM

I have an issue with Excel 2007 and I wonder can you help.

I have a Column A that you can select a “Yes” or “No” for each cell which I have set up under Data Validation.
Based on this if I select “Yes” in cell A1 it should have no effect on cell B1.
Based on this if I select “No” it has the effect that cell B1 is populated automatically with a Zero.

Can you assist??? As I cannot get this to work correctly...

**zbor** · 10-12-2009, 07:09 AM

=if(a1="yes";formula;0)

**Mondy** · 10-12-2009, 09:59 AM

I have put this formula into the conditional formatting for Cell B1
but I get an error in formula all the time in the version of Excel 2007..sorry..

**zbor** · 10-12-2009, 10:02 AM

try replace ; with ,

=if(a1="yes",formula,0)

and instead of FORMULA write what's actuall formula in your cell (B1).

**Mondy** · 10-12-2009, 10:06 AM

Cell B1 has a drop down box to select 1 or 2 if it is not populated
automatically with the zero...

**Mondy** · 10-12-2009, 10:11 AM

I have attached a JPEG of the worksheet it migh make it clearer what I am trying to accomplish...

Thanks for the help..

**zbor** · 10-12-2009, 10:15 AM

I think it's easies to add one more column like (for example) SUMARRY on the right

And write in it:

=IF(C19="No",0,IF(C19="YES",D19,"Wrong answer"))