I need a way to find cells that contain information that is included in
another cell.
Example:
A B
1 John Smith Smith, John
2 Jane Doe ABC Company
3 Billy Jones Jones, Billy

I'd like to use conditional formatting to highlight cells B1 and B3 because
it contains a word that is also in cells A1 and A3 respectively.

Thanks