Buzz
With the need to input large amounts of data into Google Sheets, duplicate data often occurs and seems unavoidable. However, before referring to how to delete duplicate data on Google Sheets, Mytour suggests highlighting them for easy tracking and pre-checking. This will help you avoid unnecessary mistakes and make it convenient to find them later.
There are two ways to highlight duplicate content in Google Sheets. Both of these methods work well even in different situations.
HIGHLIGHTING DUPLICATE CONTENT IN GOOGLE SHEETS USING COLOR
This method highlights all duplicate content using color for your convenience in checking them. This formula is the simplest and most effective one.
Step 1: Open the spreadsheet page you want to highlight duplicate content
Step 2: Select the column you want to highlight
Step 3: Select Format on the toolbar and then choose Conditional Formatting
Step 4: In the Apply to range section, the selected data column will automatically be added.
Step 5: In 'Format cells if', we change the value here to 'Custom formula is'
Step 6: Enter the following into the cell below: '=countif(A:A,A1)>1'
Step 7: In the Formatting Style section, you can change the color to fill in the cells. Here, I choose red. Then click Done to complete
Now, duplicate data will immediately be highlighted in red. Now you can double-check to see if this data needs to be deleted.
Here is a guide on how to highlight duplicate content in Google Sheets. Mytour hopes that with this article, you will be able to highlight duplicate content for easy tracking and checking whether the content needs to be deleted or not. If you encounter any difficulties during the process, feel free to comment, Mytour's technical team will support you. There are also many other tips for using Google Sheets to help you work more efficiently. In general, Google Sheets usage has many similarities with Microsoft Excel tools.
