To check for duplicates, choose the cells you want to check.
Note that duplicates in the Values section of a PivotTable report cannot be highlighted in Excel.
Duplicate Values can be found by going to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

Select the formatting you want to apply to the duplicate values in the box next to values with, and then click OK.
