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.:
Cell Value - Contains - “supermarket1”
But I want to include a list of words, e.g.:
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?