Conditional Formatting to search a word from one column to another.

[tazmaniangriffin]

Hi Excel Experts,

Good Day.

I have searched almost the entire form to see if this has been brought up already and I think nothing yet so I am putting it in here to ask for your valuable inputs.

I have an excel contains 2 columns, i.e., Top 30 keywords (column A) and new generated keywords (column B).

Please help me identify a conditional formatting or any other way wherein column B will check with Column A if there were words in column B that did not exist in column A. Example, column B have the words "average, business, industrial, advertising, marketing, paper, social, online, men, women, dad, mom, single, writer, ashleewith2es, displayed, front, order, contact, pages, suited, timeless, accessible,", and if you look at column A one of the words in there were PUBLISHED but its not found in column B. So is there a way to use a conditional formatting wherein it will column B if there are ANY words that were in column A but no longer found in column B.

I appreciate your valuable inputs in advance.

I attached here a sample file.

[tazmaniangriffin]

Hi Guys,

Anyone can help me on this scenario?

Any help will greatly be appreciate.

Thanks.