Excel

Sandra apologies for the delay

The best way to highlight duplicates in a list is to find a unique column such as an account number.

Please find attached a spreadsheet called "conditionally format duplicates" that shows you how to apply conditional formatting to a single column to format duplicates in that column

The first sheet has the steps involved and the formulas in the worksheet. Also I have taken a screenshot of what should be entered in the conditional formatting dialog box.

The second sheet just has the data for you to practice on.

Many thanks

Hope that helps