I have several pick lists that I need to apply some error checking to and was thinking of using conditional formatting.

I have 15 dropdowns that draw from a list of names. I need to format the cell background colour if that name exists in any of the other 14 dropdowns.

Suggestions and examples greatly appreciated.

Cheers