Highlight Duplicate Two Column

[prititit]

Hello!

I want to automatically highlight those duplicate for example in Column A and Column C in EXCEL.

Sample:
Column A
18-19999
18-23232
23-92826
34-22934

Column C
43-34387
23-92826
43-35342
18-19999

Thank you!

[KarthikByggari]

Output:

Steps:

Regards,
Karthik Byggari

[Divyashreem (Divyashree Muddagangaiah)]

You can achieve this using macro as well