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:
But had no luck. Could you please help.=if((E4)="Yes","Skip","")
Cheers.Conditional Formatting.xls
Bookmarks