Ask Your Question

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

asked 2021-05-01 20:04:27 +0200

librelaleche gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-05-02 13:32:45 +0200

Zizi64 gravatar image

updated 2021-05-02 13:43:39 +0200

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

Or see this question:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2021-05-01 20:04:27 +0200

Seen: 20 times

Last updated: May 02