highlight cells which were found in a list of words

[hadar]

Hello,

I would appreciate any help..

I have a list of words which I would like to know if column C contains each one of them in each cell, if it's true I would like to highlight the cell in red.
any ideas?

with conditional formatting I'm able to create one rule for one each each time..

for example:
Coulmn C
microsoft.com
excelforum.com
netfflix.com
dfdfcode.blog.com

List of words:
Code
microsoft.com
forum

 

[NBVC]

Select column C, then invoke conditional formatting,

Assuming Excel 2007 or later, choose "use a formula to determine which cells to format"

Then enter a formula like:

=OR(ISNUMBER(SEARCH($G$1:$G$3,$C1)))

where G1:G3 contain the words to look for, and C1 is top most cell in your selection.

Click Format and choose from Fill tab.

Note, this highlights the whole cell/word, not just the matching part.