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

How to Use Excel to Show Only Duplicate Values. Business issues such as incorrect transactions, data entry errors, technical glitches and poor system design may cause duplicate values in your data ...

How to Show Duplicate Records in Excel. As your business grows, so too will the documents and spreadsheets that you use to help keep things running. Eventually, the spreadsheets may get so big ...