Conditional formatting on a cell with a drop down list

[bizzyboy]

Hi Folks,
i am trying to apply conditional formatting to one cell based on the result of another cell that has a drop down list contained in it.

so for example if cell A1 has a "yes"/"no" drop down list applied to it i want A2 to turn red if "no" is chosen.
the conditional formatting i am able to do in cells without drop down lists but not with a drop list.

can anyone offer any solutions.

i am using Office 2010

thanks in advanced.

BizzyBoy

 

[dave3009]

In cell A2 apply conditional format>>Formula Is>>A1="Yes" and apply green format, Add another for "No" and apply a red format

 

[bizzyboy]

Dave,
thanks for the swift reply, tried that, no success.
do you apply the conditional formatting after applying the drop down list or the other way round?
believe me i've tried always, i must be missing a trick some where !!!
i am using Offcie 2010 on Win7

regards

Bizzyboy

 

[dave3009]

I'm not sure what the issue is, I put a dropdown in A1 with the choices of Yes and No. I went to cell A2 and in that cell I applied 2 conditions,

1st was Use formula to determine format>>=A1="Yes">>I set a green format.
2nd was Use formula to determine format>>=A1="No">>I set a red format.

Now when I change the dropdown in A1 the colour of A2 changes accordingly.