Highlight duplicates in a column, except for the first one in Excel and Google sheets. This allows for simple filtering and deletion of keywords.
Highlight the Column/cells you want to find duplicates.
Go to Conditioning formatting.
Enter below in the custom formula section. Adjust values of column and cell if the range does not begin at A2.
=COUNTIF($A$2:$A2, A2)>1