Conditional Format Formula

[Mista_sav]

Hi Team, im trying to write a conditional format that is like "Cells that contain a specific word" Contain being the main thing as the cells contain multiple words.

- So my range is the C column
- I want it to highlight a color if the Cell contains say the word "Woolworths" or it might say "KFC" The cells themselves might say Woolworths NZ 123456 but i only want it to trigger off the word "Woolworths"

Can i do one formula so i dont have to process multiple Conditional Format?

Because each file is new, it will have different keywords so i will just attach it to a macro to run the conditional format to highlight the cells with the desired words

 

[Cubist]

So basically each cell is a word that could appear in certain cell that we download. I want it to highlight a colour depending on the word so 9 categories i would do 9 conditional formats. Otherwise id have to do like 100 CF hahah

I don't see why what I suggested in post #6 won't work for you. You'd just have to duplicate the sheet containing the search words into each workbook and then apply the formula.