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

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