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

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.