Excel - If Equal to Value in Range, Then Highlight Value in Range

Vote count:

0

I have two columns of data - a reference column All Names and another list of names Performer which meet a certain criteria (the criteria is not relevant here).

Names contains 2029 names, Performer contains ~120 names. They are not matched up (i.e. Bill Smith does not sit beside Bill Smith, but rather beside Jessica Hart).

What I want to do is to check each name in Performer against the list Names, and if it exists within Names, I then want to highlight the value in Names so that I can easily identify it.

For example, if Bill Smith (which resides in Performers) exists within Names, then I want to highlight the value Bill Smith in Names.

How can this be achieved?

asked 1 min ago

SnookerFan

705