I need a cell to be highlighted if its text is found in another cell's contents. For example, B1 has one word in it, "dog" and B2 contains one word, "cat". C1 contains the phrase "the dog runs fast". Because B1 contains the word "dog", which matches a word in the C1 phrase, I need to highlight B1, while C1 would not be highlighted because it doesn't contain a word found in the C1 phrase.
Solved by E. H. in 21 mins