Highlighting duplicates

[t1o9n9y1]

I am trying to highlight duplicates across two columns. So when a selection from column A and a selection from column B occur more than once together in the table, they are then highlighted. I can get it to work with duplicated entries from a single column, but not from both.

So for example,
[TABLE="width: 500"]
<tbody>[TR]
[TD]ABC[/TD]
[TD]DEF[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]DEF[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]GHI[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]JKL[/TD]
[/TR]
</tbody>[/TABLE]

In this instance, only the top two rows should be highlighted. Is this possible at all?

Cheers for any help.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ional-formatting-post5210945.html#post5210945

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).