Highlighting duplicates in Excel is a handy feature! You can do this by selecting your data range, then going to the Home tab, clicking on 'Conditional Formatting', choosing 'Highlight Cells Rules', and selecting 'Duplicate Values'. Excel will then highlight the duplicates for you.
Do you work with large datasets often, or is this more of a one-time task? It can be a real time-saver in both scenarios!