Suppose, we have records containing duplicate values. And we want to find records that can repeat many times in records in Excel. So, In MS Excel tools provide following way to find **Duplicate value in Excel** or **Find Duplicate in Excel**.

- Find Duplicate through Simple Process in Excel
- Find Duplicate with Custom Color or Style in Excel
- Find Duplicate through Function in Excel
- Find Duplicate Row in Excel Using Formula

So, Lets start with every option in given above with following steps:

**(1). Find Duplicate through Simple Process in Excel :**

For Simple Process, you have to follow the steps:
**1.**

**2.**

**Conditional Formatting**” option from “

**Home**” Tab.

**3.**

**Conditional Formatting**”, it will show popup List Containing many options.

**4.**

**Highlight Cells Rules**”. It also shows a list of Option. Click on “

**Duplicate Values..**” option.

**5.**

**Duplicate Vales**” window. Contains options and Color indicator for duplicate value.

**6.**

**OK**” button. This will highlight duplicate values or items with chosen color.

**duplicate items in MS Excel**.

**(2). Find Duplicate with Custom Color or Style in Excel :**

If you want to change Duplicate Item’s cell’s color, border or font then, you have to follow steps:
**1.**

**2.**

**Conditional Formatting**” click on “

**New Rule…**” from it.

**3.**

**New Formatting Rule**” dialog.

**4.**

**Format only unique or duplicate values**”. After this option selection, press “

**Format…**” button. This will show “

**Format Cells**” dialog.

**5.**

**Font**” Tab. If you want to change border Style then go to “

**Border**” Tab. If you want To change cell’s

**background color**then go to “

**Fill**” Tab.

**6.**

**OK**” button from “

**Format Cells**” dialog. Then press “

**OK**” button from the dialog of “

**New Formatting Rule**”.

#### This way you can **Highlight Duplicate in Excel**.

**(3). Find Duplicate through Function in Excel :**

Now if you want to find duplicate items through custom rules applying with formula. Then we have to use “**COUNTIF**” function like following steps:

**1.**

**Conditional Formatting**” then click on “

**New Rule…**”.

**2.**

**New Formatting Rule**” dialog. Here we select “

**Use a formula to determine which cells to format**”. After selecting this, “

**Format values where this formula is true:**” Formula Box will appear.

**3.**

**=COUNTIF (range, criteria)>1**

**=COUNTIF(Selection Of Rows and Columns, Selection For Which cell will be count) > 1**

Example:

**=COUNTIF($A$2:$B$11, A2:B11) >1**

**4.**

**Format…**” button for color and style of duplicate items. Then click “

**OK**” button.

**(4). Find Duplicate Row in Excel Using Formula :**

Suppose, you want to check duplicate Row in Excel not duplicate cell. Then you have to use same process as describe above but using different formula “**COUNTIFS**” with following steps:

**1.**

**Conditional Formatting**” then Click on “

**New Rule…**”.

**2.**

**New Formatting Rule**” dialog. Now go to the option “

**Use a formula to determine which cells to format**”. After Selecting this, “

**Format values where this formula is true:**” Formula Box will appear.

**3.**

**=COUNTIFS($A$2:$A$11, $A1, $C$2:$C$11, $C1)>1**

This will show

**Duplicate Row in Excel**.

**duplicate items in Excel**and

**Duplicate rows in Excel**and find

**Duplicate in Excel**with easy tech tips.