Hello all,

Apologies if I have duplicated a topic already posted but my problem seems to be a little different than the ones I've seen here.

I have two address lists that are formatted differently. One list, 'Symphony,' has names combined (Mr. and Mrs. John Smith) and the second list, 'Library,' has first and last name fields. I need to search the Symphony list and highlight any combined names that might have "Smith" in them. I don't want it to automatically delete these fields because there may be more than one person with the last name Smith.

So, essentially, what I would like to do is search each cell in the 'Symphony' Combined Name column and see if it has any word that is contained in the 'Library' Last Name column. Then I would like it to highlight that cell. If the highlight is not possible then I would even take my chances with just deleting them at this point.

Thank you so much for any advice you could give.