Hello,

I've looked through a few threads, but have been unable to make this one work for me.

As per the attached spreadsheet - I am looking to format my cell with the words 'Skip', along with a pattern background if a dropdown box value of 'yes' is selected. I've been trying to use the formula:

 =if((E4)="Yes","Skip","")
But had no luck. Could you please help.

Cheers.Conditional Formatting.xls