Conditional Formatting is a very handy tool in Excel, especially when working with lists that include companies and addresses. Often if you are working in a list you want to find duplicates to remove, but maybe the company names are the exact same, or there are so many in your list it will literally take hours upon hours to complete. This is where Conditional Formatting will come in handy for you.
In our example the spreadsheet is a list of companies with contacts, phone, email and address. I don’t want to send the same company my mailing so I want to find duplicates.
Step 1: Highlight column you wish to find duplicates in.