Click “Done” to save changes, review your duplicates, and delete those you find as legitimate copies.

Under the “Formatting style” section, select the “Fill color icon” to highlight your content with a yellow (or any color of your choosing) cell background.

Paste the following “formula” into the box located under the “Custom formula is” option:.

Under “Format rules,” change the drop-down section titled “Format cells if…” to “ Custom formula is.”.Select the “range” you want from the new menu that appears.In the drop-down menu, select Conditional Formatting.In the menu bar at the top, select “Format.”.Open your “Google Sheets file.” and highlight the “column or columns” you want to edit.When it comes to identifying errors in your spreadsheets, using highlights to spotlight any incorrect information is another good way to go. Highlight Duplicates using Colors for Easy Removal A great way to do that is with color highlighting. Using Google Sheets’ built-in “Remove Duplicates” feature is the most straightforward way to eliminate duplicate entries, but sometimes, you might want to review the copies before removing them. Google Sheets displays how many copies were found and removed so that you can ensure the process worked as intended.Mark the boxes next to each column in the list you want to check, or you can check off the “Select All” box and then click “Remove duplicates.” In the menu at the top, select “Data -> Data cleanup,” and then choose “Remove duplicates.”.

Highlight the columns you want to check for duplicate data.

Find and merge duplicate rows in excel