To highlight only Unique values in a data set, conditional formatting can be used.

Steps: –
1. Select the data where you need to highlight only the Unique values

2. Go to Home tab, and click on Conditional Formatting.
3. Choose the option, Duplicate Values…, under Highlight Cell rules.

4. Select “Unqiue” from the drop-down, and select the kind of formatting required.

You’re done!
Keep Excel-ing!