Excel Formulas to Highlight Duplicate Rows ~ Simple Tutorial!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-30 12:05:29

---
title: Excel Formulas to Highlight Duplicate Rows ~ Simple Tutorial!!
published: true
date: 2021-03-30 04:29:03 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-duplicate-rows/
---

In the previous post, we have seen how to highlight the duplicate columns in Excel. Similarly, here we are going to look up the simple formula to **highlight the duplicate rows in Excel**. Let’s get them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Highlight duplicate rows](https://geekexcel.com/wp-content/uploads/2021/03/Highlight-duplicate-rows.png)](https://geekexcel.com/excel-formulas-to-highlight-duplicate-rows/highlight-duplicate-rows/#main)<figcaption id="caption-attachment-22710">Highlight duplicate rows</figcaption>
## Generic Formula:

- If you want to highlight the duplicate rows in Excel, use the below formula.

**=[COUNTIFS](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)(A:A,[$A1](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/),B:B,$B1,C:C,$C1)**

## Syntax Explanations:

- **COUNTIFS**  – The Excel**[COUNTIFS Function](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)** will help to count the number of cells that meets multiple criteria or condition.
- **Absolute Reference ($)** – The [**Absolute Reference**](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) is an actual fixed location in a worksheet.
- **A, B, C** – These are the input ranges from your worksheet.
- **A1, B1, C1** – It represents the criteria value from the input ranges.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input values in **Column B** to **Column E**.
- Here, we are going to highlight the duplicate rows.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-36.png)<figcaption id="caption-attachment-22711">Input Ranges</figcaption>

- Enter the formula in **Cell G3** , and drag it down to get the result on other cells.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result-40.png)<figcaption id="caption-attachment-22713">Result</figcaption>

- Now apply the same formula in the conditional formatting option.
- To know  **how to apply conditional formatting**  in Excel, just **refer to this article<u>:</u>[ How to Apply the Formula with Conditional Formatting In Excel?](https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/)**
- Finally, it will highlight the result and displayed it as shown below.

![Result 1](https://geekexcel.com/wp-content/uploads/2021/03/Result-1-3.png)<figcaption id="caption-attachment-22712">Result 1</figcaption>

## Wrap-Up:

Here, we have described the formula to **highlight duplicate rows in Excel**. Let me know if you have any **doubts** regarding this article or any other **Excel/VBA** topic. Thank you for visiting our site!! To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Highlight the Cells Between Two Dates!!](https://geekexcel.com/excel-formulas-to-highlight-the-cells-between-two-dates/)**
- **[Excel Formulas to Highlight the Dates Greater Than Given Date!!](https://geekexcel.com/excel-formulas-to-highlight-dates-greater-than-given/)**