Highlighting Ends of Duplicate Records
There is an Excel file that teaches how to perform the Highlighting Ends of Duplicate Records operation.
Excel Spreadsheet for Highlighting Ends of Duplicate Records
This file marks later duplicate entries so repeated records become easier to review.
Hope it is useful.