Excel: Highlight cells with specific words from list of words


Hi, I am working on a project and I need to search columns of data to see if a specific word/phrase is in there. I need a way to search a list of words and highlight cells that do not have any of those words. To be exact, I would like to search a number of columns for the phrases

Flower
Edible
Oil_Wax
Capsule_Oral
and highlight any cells that do not have any of those words, case sensitivity is crucial. Thank you for your help. Quang


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of April 13, 2017.


For more resources for Microsoft Excel