Colour match each duplicate with Excel's conditional formatting
Google Sheets - Highlight Duplicate Data in a Column or Row
Highlight Duplicate Values in Excel in Same Column in a Different Colour
How to mark or highlight unique or duplicate values in excel