I have a list of nearly 700 words on Sheet2 that I need to use to search for cells that contain those words on Sheet1 and have them flagged by filling them with red so I can manually review them.
All of the words on Sheet2 are in Column A starting with cell A3. I've done my best to go through the words and break them down into individual words and various spellings.
For example: **Burger King** has three versions, "Burger King," "burger," and, "king".
I have a conditional formatting rule that works but only if a cell on Sheet1 contains exactly what's in the cell of Sheet2:
=COUNTIF(Sheet2!$A:$A,A1)>0
But if Sheet1 has a cell that contains something like "Burger Kings," it won't be flagged because it doesn't match an exact cell from Sheets despite containing the same words as a cell from Sheet2.