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

Ask Your Question
0

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
0

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

2 followers

Stats

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

Seen: 23 times

Last updated: May 02