I have a spreadsheet with an exhaustive list of names (ALL NAMES).

I then have several other sheets (Silver, Gold, Top, Art, Music, Latin, Key) that have the names of various award recipients (a subset of the ALL NAMES).

I want to be able to apply conditional formatting (or something) highlighting the names on the exhaustive list that appear on each additional sheet (that way I can remove any names that are not receiving awards) 

​I have a spreadsheet with an exhaustive list of names (ALL NAMES). I then have several other sheets (Silver, Gold, Top, Art, Music, Latin, Key) that have the names of various award recipients (a subset of the ALL NAMES). I want to be able to apply conditional formatting (or something) highlighting the names on the exhaustive list that appear on each additional sheet (that way I can remove any names that are not receiving awards)   Read More

​