I take it back. This solution is not 100% accurate. Would really appreciate help!
Column AColumn B
New YorkBoston
CaliforniaChicago
BostonCalifornia
Based on this example, I would like to conditionally highlight "California" and "Boston" in column A because they matched values in column B.
How can I do that, please???
Bookmarks