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

I think I've figured it out! But I'm not sharing my solution until someone on this forum presents their solution!

like this?

=OR(NOT(ISERROR(FIND("Sheet2!$D$2:$D$13",INDEX($C:$C,ROW())))),NOT(ISERROR(FIND("Sheet2!$D$2:$D$13",INDEX($C:$C,ROW())))))

KR