Search notes:

Excel: Home -> Styles -> Conditional Formatting -> Highlight Cells Rules -> Duplicate Values

Although named Duplicate Values, this functionality also allows to highlight unique values.

See also