Still having no joy with this - I feel so dense!
I am trying a simpler approach first on some copy/pasted data;
eg Sales, Finance, Marketing, Services
I want to check for any imported data that contains errors such as typos or incorrect depts. I tried a Conditional Format rule for one of the words and it worked.
However, as soon as I added further rules for the other words the whole thing fell apart.
Can anyone point me in the right direction? I have tried formulae with AND as well as OR but nothing works.