Hi Team,
I have an issue with my conditional formatting. I have a standard duplicate format and I also have a conditional formatting formula that STOPS that duplicate formatting if a condition is met.
E.G. Column B lists locations. If the location is repeated it will format it yellow as it is a duplicate. However, should the cell adjacent in column E have either 'Verbal Negative' or 'Non-Escalation' it will stop the duplicate process which is great and is what I need!
However, it also stops the other cells being highlighted if the adjacent cell in column E contains "911" or "Escalation" which is not what I need. I need to the duplicate formatting to reapply itself to these circumstances.
E.G
B -------------------------- E
C12------------------------ Verbal Negative
C12------------------------ Escalation
C12------------------------ 911
C12------------------------ Non-Escalation
So B1 and B4 should not be highlighted, but B2 and B3 should be.
Please see attached what I mean. Im probably making it more complicated than it needs to be.
Bookmarks