Hi Team!
I have a standard highlight duplicates conditional formatting on Column B. However, I also have another conditional formatting formula for Column B which references to Column E.
For example,
B:
C148
C148
These would be highlighted.
The secondary formula stops the highlighting if Column E meets a certain criteria (If the cells contains Non-Escalation).
However, if the other cell that is a duplicate is linked to the cell in Column E contains 'Escalation', it would stay highlighted as it still meets the duplicate formatting criteria.
I don't need it to be highlighted as it would no longer count towards being a duplicate due to it being a non-escalation.
Is there a formula to help with this?
PLEASE see attached what I mean if I don't make sense.
Bookmarks