Display Duplicate
Select the cells you want to check for duplicates.
Click Home Conditional Formatting Highlight Cells Rules Duplicate Values.
In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK.