How to Highlight Cells that Contain only Unique Values

Using conditional formatting, you can quickly highlight the cells that contain only unique values. Please follow the steps below:

Step 1: Select the data cells or the data range;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Conditional Formatting" command in the "Styles" section;

Step 4: Select "Highlight Cells Rules" in the drop-down list, then click "Duplicate Values" from the extended list;

Step 5: In the new window, select "Unique" in the first box. You can always change to a different color from the second box;

Step 6: Click "OK" at the bottom and you will see the unique values are now in a different color.