In Google Sheets, you can highlight the duplicates using the conditional formatting. You can also quickly remove the duplicates with the command.
Step 1: Click anywhere in the data range;
Step 2: Click the "Data" tab from the ribbon;
Step 3: Click "Remove duplicates" from the drop-down list;
Step 4: In the new dialog box, decide how you want to remove the duplicates, e.g., remove duplicate based on column A;
Step 5: A quick summary message will display;
Step 6: The data range after removing duplicates will display.