Forum Discussion
Excel conditional formatting
Hi all! Im having a tough time figuring this one out. I usually use conditional formatting to find unique entries between two columns, however I now need them to be date specific. I want it to flag ...
sorry for the confusion! It’s my first time posting. Above the duplicate cells are highlighted based on the dates. Even though there are other duplicate values i dont want them to highlight because they didnt occur on the same date.
For conditional formatting: Simply combine the search terms with each other!
Column B:
=ISNUMBER(XMATCH(A2&B2,C$2:C$7&D$2:D$7))
Column D:
=ISNUMBER(XMATCH(C2&D2,A$2:A$7&B$2:B$7))
