How to highlight unique values in Excel

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