Highlighting duplicates in Google Sheets

 

Highlighting duplicates is a good feature that makes your Google Sheets document look amazing. To highlight duplicates in Google Sheets, follow these steps to do it:

1. Open your Google Sheets document.

2. Now, select the range of cells where you want to make  duplicates.

3. Now, Click on Format in the menu.

4. Based on your interest, Choose Conditional formatting from the dropdown menu.

5. In the Conditional format rules pane that appears on the right, select “Custom formula is” from the dropdown.

6. Enter the formula

 `=COUNTIF($A$1:$A$100, A1)>1` (replace `$A$1:$A$100`

with the actual range you selected).

7.  Based on your interest, choose the formatting style for the highlighted duplicates.

8. Click Done to apply the conditional formatting.

Now, any you have highlighted the duplicates