Conditonal Format or Formula help please
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
|