To highlight duplicate or unique values in Excel: • Select the cell range • Under home select conditional formatting • Select highlight cell rules • Select duplicate values • From here you can set it to highlight duplicate or unique and change the color that you want these values to be highlighted