highlight duplicates in google sheets
Open your spreadsheet in Google Sheets and select a column. For instance, select column A > Format > Conditional formatting. Under Format rules, open the drop-down list and select Custom formula is. Enter the Value for the custom formula, =countif(A1:A,A1)>1.