I have two sheets called Sheet1 & Sheet2.
Sheet1 contains two columns of text data, C & D, with 1000 rows (i.e. C2:D1001).
Sheet2 contains one column with 10 words (D2-D13).
I want to highlight an entire row in Sheet1 if the following conditions are met:
Parse all of the text in Sheet1!C2:D2
If any part of that text matches one or more of the words in Sheet2!D2-D13, then highlight the entire row in Sheet1 that contains the match.
Move on to the next row and repeat the partial match.
Is there a way to set up this type of conditional formatting?
-Pete