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

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

Question is not clear.

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