Hi there and thanks in advance for any help given. You guys have been tremendously helpful.

I have been using the conditional formatting function to find and mark cells in a column which contain various words. The list of words is getting quite long now and I was wondering if there is a quick way to cross check the list and do the conditional formatting as a bulk formula or VBA command? Would prefer formula is possible. Or can I even use the conditional formatting function and use a separator and do all the words at once? Thanks so much.

Casey.