Highlighting Duplicate values in Excel

Sometimes such a simple thing makes the difference when you’re staring at a lot of data in Excel.

I always set this just in case I’ve got some duplicate records that were missed on a data dump.