One of these, is the ability to highlight duplicates.

As with all conditional formats, we need to define a rule.

First, grab the data in the table.

All unique values are formatted and duplicates are left alone.