---
title: "How To Highlight Duplicates In Google Sheets"
h1: "How To Highlight Duplicates In Google Sheets"
description: "Learn how to easily highlight duplicates in Google Sheets with our step-by-step guide. Enhance your data management skills and streamline your workflow today."
route: "/learn/how-to-highlight-duplicates-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-highlight-duplicates-in-google-sheets"
---

# How To Highlight Duplicates In Google Sheets

Identify duplicate values in Google Sheets using conditional formatting. Learn how to apply formulas and highlight repeated entries automatically.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm8olurpp0001jr0cemjjsupf/tour

Tour id: cm8olurpp0001jr0cemjjsupf

1. Open **Google Sheets** and select the range where you want to find duplicates.
2. Click on **Format** > **Conditional formatting** from the menu.
3. In the **Format cells if** dropdown, choose **Custom formula is**.
4. Enter the formula: `=COUNTIF(A:A, A1) > 1` (replace `A:A` with your column range).
5. Choose a **highlight color** under the Formatting style.
6. Click **Done**, and duplicates will be highlighted automatically.