Forum Discussion
MikeC890
Mar 30, 2022Copper Contributor
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...
OliverScheurich
Mar 30, 2022Gold Contributor
You can try the attached file. Maybe this is what you want to do.