Excel sheets have always been the foundation of huge data sets. They allow you to manage different items easily and automatically, while at the same time ensuring that you can use functions, formulas and all the other features that spreadsheets offer.

While spreadsheets are great in their own right, they can’t prevent you from having duplicate entries. This means you have to manually find them and take care of them yourself when necessary.

While removing duplicates in Google Sheets is easy, what about highlighting them? Let’s find out!

We use conditional formatting to find and highlight duplicates in Google Spreadsheets.