Apply conditional formatting 'if' the cell contains a validation list

[jamesgc]

I have a table. I want to apply conditional formatting to the entire table so that wherever a cell contains a dropdown list (validation list) the cell is formatted with a different colour.

Any ideas?

Thanks.
James

[martindwilson]

not without code, but a quick way is to goto /special /data validation then just pick a colour
Click> FIND & SELECT on the HOME tab in the EDITING group and Click> GO TO SPECIAL. This will open the GO TO SPECIAL dialog box.

[Rahul Nagar]

Please check the attached file, hope this will help you.

[martindwilson]

Rahul Nagar i cant see how that helps ?what if there is another validation list with say a,b,c in it?
what if there is a cell with just 3 and no validation in it that would get coloured as well