How to mark duplicates in Google Sheets | Scribe

How to mark duplicates in Google Sheets

5 steps | 19 seconds | Created by Tiffany from Scribe
google.com
This Scribe shows you how to visibly mark duplicates in a single column in Google Sheets using conditional formatting. The same logic came be applied to multiple columns i.e. entire datasets
1
Navigate to your spreadsheet
2
Select the second cell in the column where you want to mark duplicates. If your column does not have a column header, select the first cell
3
Highlight the entire column of data: For PCs, press CTRL + SHIFT + DOWN. For Macs, press CMD + SHIFT + DOWN
4
Click "Format" and then "Conditional formatting"

Tiffany made this Scribe in 19 seconds.