Greg,

Assuming the Master list is in column A and the list that you are
comparing to the Master is in column C.You want to highlight those
names that occur in both lists in Column D.
- firstly sort the Master list in alphabetical order
-in Column D enter the following formula =VLOOKUP(C1,A:A,1,0)&"*" and
drag it down
- All item appearing in the master list will get the * and those not
appearing will return #N/A
Hope this is what you had in mind
Steve