The easiest way to spot a unique value is to format it, and Microsoft Excel offers two ways to do so.

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