Highlist a list of terms within a range

[nard416]

example, I would like to find and highlight all instances of the words in column A throughout column B and C. Please help. Thank you.
[TABLE="width: 500"]
[TR]
[TD]Happy
[/TD]
[TD]The bike was black and green
[/TD]
[TD]what are you happy about
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dog
[/TD]
[TD]Happy birthday to me
[/TD]
[TD]did your cat and dog ride your bike her
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cat
[/TD]
[TD]The guy road his bike with his cat and dog
[/TD]
[TD]I can buy rum at the store
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rum
[/TD]
[TD]I don't like rum or dogs
[/TD]
[TD]The cat is happy
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bike
[/TD]
[TD]I'm happy and enjoy drinking rum
[/TD]
[TD]The happy dog is drinking rum
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]

 

[Scott Huish]

Duplicate post.

See: http://www.mrexcel.com/forum/general-excel-discussion-other-questions/832384-highlist-list-terms-within-range.html