Thread: Error trapping
View Single Post
 
Old 12-21-2017, 12:11 PM
Ricco49 Ricco49 is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Oct 2017
Posts: 7
Ricco49 is on a distinguished road
Default

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.
Reply With Quote