Conditional Formatting Question Regarding Duplicate Items in a column

Hello,

First time visitor, first time poster...

I have 3 lists of names. Names within each list may have duplicates, and names among all the lists may have duplicates too. I've combined the 3 lists and color coded the cells to differentiate which list each name came from. I then sorted the 3 lists in alpha order so all lists are intermingled.

My goal is to highlight the duplicate names if and only if they appear in more than one list, but not if they appear in only one list. For example, if John Drake appears twice in list A, then don't highlight, but if he appears in list A and B, then highlight. I've figured out how to highlight the name if it has a duplicate (regardless of cell color); however, is there a way to include cell color as a conditional factor so that it only highlights if the cell colors are different?

Thanks in advance,

E

Instead of color coding to show list source, use a separate column with the source list number. Then commingle the lists and sort the ensemble by name. The conditional formatting to detect duplicates within and between lists will be simpler.