Compare with two column and return value or highlight match word(s)

[chanccl]

Dear Expert,

I want to compare with two column A and B and find any match word(s).


This is an apple
apple is red


best friend
this is the one



lets go



my friend



cup of water



For example, base on column A "This is an apple" compare to each cell in column B. any match word will highlight it. or return true/false on column C.
Please help on this with many thanks!

chanccl

[snb]

Question is not clear.

[jolivanes]

What is the maximum amount of rows you would have in both Column A and Column B?