Forum Discussion

MikeC890's avatar
MikeC890
Copper Contributor
Mar 30, 2022

How to set up a rule to search Sheet1 for a list of word, or parts of words, on Sheet2.

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. A...