Conditional formatting for 'Cell Value' 'contains' with several words

[librelaleche]

Hi, I am trying to use conditional formatting in a column.

I want it to change the background colour of cells that contain key words.

I have it working for one word, e.g.:

Condition
Cell Value - Contains - “supermarket1”

But I want to include a list of words, e.g.:

Condition
Cell Value - Contains - “supermarket1”, “supermarket2”, “supermarket3”

And then have the colour change for all of the cells containing those particular words but in the range of cells in the column.

Or if possible, I would have a list of words in another sheet that could referenced.

I am hoping someone can please help?

[Zizi64]

You can try to use the OR() function in the Condotional Formatting feature too.

Or see this question:

Changing cell format if it contains text from a list

Hi everyone, I have a rather complicated thing to do ( at least I think ) I have a list of words on the first sheet of my file. ( it’s at least 20 rows long ) example : Cow Bird Shovel On the other sheets of the file, I want the following behavior : I would like that if my cell doesn’t contain any of the words of my list ( cow, bird or shovel ), it turns red ( change the style ) I’ve tried conditionnal formatting. But it’s very long and hard to change, and the software starts crashing a…