Google Sheets can be used to highlight duplicates in a spreadsheet. How the repeats are displayed is fully customizable in the formatting style options. This can be used to represent specific reasons for why a duplicate was highlighted so it makes sense to anyone looking at the data. For instance, you can highlight the entire row of a given column containing any duplicates. Or, alternatively, it can also be formatted to simply highlight any cell with a value that appears more than once in the spreadsheet. Continue reading
How to Highlight Duplicates in Google Sheets
