We will be migrating from Ask to Discourse on the first week of August, read the details here

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: https://ask.libreoffice.org/en/questi...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



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

Seen: 24 times

Last updated: May 02