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.