How to highlight duplicate values in Excel

Microsoft

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.