Enter:
Go to tab → Conditional Formatting → New Rule . how to highlight duplicates in excel in two columns
(Assumes first data row is 2.)
Choose .