Compare Two Ranges to Select/Shade Duplicate or Unique Values in Excel 365!!
Tags: comparetworanges, kutoolsexceltutorial, kutools
Published: 2020-11-19 09:59:23

---
title: Compare Two Ranges to Select/Shade Duplicate or Unique Values in Excel 365!!
published: true
date: 2020-11-19 09:54:39 UTC
tags: CompareTwoRanges,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/compare-two-ranges-to-select-shade-duplicate-or-unique-values-in-excel-365/
---

Let’s see how to **Compare Two Ranges to Select/Shade Duplicate or Unique Values in Excel Office 365** with **Kutools.** 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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Compare Two Ranges & Find Same/Different Records Based on Each Row:

To compare two ranges and find the same or different records in each row, do as below steps.

- You need to **hold down** the **CTRL key** and **select two ranges** that you want to compare.

![Select two ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-two-ranges.png)<figcaption id="caption-attachment-17662">Select two ranges</figcaption>

- Next, on the **Kutools Tab, click** on the **Select** option, then **choose** the **Select Same & Different Cells** option from the menu.

![Select the Select Same & Different Cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-31.png)<figcaption id="caption-attachment-17660">Select the Select Same &amp; Different Cells</figcaption>

- It will open the **Select Same & Different Cells Dialog Box.**
- If you forget to select the input ranges, you can use the **browse button** to **select Find values in (Range** **A)** and **According** **to (Range B)** to compare.
- **My data has headers –** If there are headers in your data, you need to check this option.
- **Based on –** Here, you need to **choose**   **Each row** option.
- **Find –** You need to **choose** the **Same Values** ( **search duplicate rows between two ranges** ) or the **Different Values** ( **search unique rows between two ranges** ) option.
- **Processing of results –** You can fill the **duplicate or unique values** with **background** color or **font color** by checking the **Fill backcolor** or **Fill font color** options.
- **Select entire rows – ** If you want to select the entire rows within the used range, then check this option.
- **Case sensitive –** If you want case sensitive comparing, you need to check this option.

![Select Same & Different Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-30.png)<figcaption id="caption-attachment-17663">Select Same &amp; Different Cells Dialog Box</figcaption>

- Finally, you need to **click** the **OK** button. It will open a prompt box to tell you how many cells are selected as shown in the below image.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-29.png)<figcaption id="caption-attachment-17664">Prompt box</figcaption>

- You need to **click OK** button to close this box.
- Now, the same or different records will be selected and colored as shown in the below image.

### Select Same Cells:

![Same values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-25.png)<figcaption id="caption-attachment-17665">Same values</figcaption>

### Select Different Cells:

![Different values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-21.png)<figcaption id="caption-attachment-17666">Different values</figcaption>

## Compare Two Ranges & Find Same/Different Cells Based on Single Cell:

If you want to compare two ranges and find the same or different cells based on a single cell, then follow the below instructions.

- First, you need to **hold down** the **CTRL key** and **select two ranges** that you want to compare.

![Select two ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-20.png)<figcaption id="caption-attachment-17667">Select two ranges</figcaption>

- Go to the **Kutools Tab, click** on the **Select** option, then **choose** the **Select Same & Different Cells** option from the menu.

![Select the Select Same & Different Cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-31.png)<figcaption id="caption-attachment-17660">Select the Select Same &amp; Different Cells</figcaption>

- It will open the **Select Same & Different Cells Dialog Box.**
- If you forget to select the input ranges, you can use the **browse button** to **select Find values in (Range** **A)** and **According** **to (Range B)** to compare.
- **My data has headers –** If there are headers in your data, you need to check this option.
- **Based on –** Here, you need to **choose**   **Each row** option.
- **Find –** You need to **choose** the **Same Values** ( **search duplicate rows between two ranges** ) or the **Different Values** ( **search unique rows between two ranges** ) option.
- **Processing of results –** You can fill the **duplicate or unique values** with **background** color or **font color** by checking the **Fill backcolor** or **Fill font color** options.
- **Case sensitive –** If you want case sensitive comparing, you need to check this option.
- Finally, you need to **click** the **OK** button.

![Select Same & Different Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-18.png)<figcaption id="caption-attachment-17668">Select Same &amp; Different Cells Dialog Box</figcaption>

- It will open a prompt box to tell you how many cells are selected as shown in the below image.
- You need to **click OK** button to close this box.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-18.png)<figcaption id="caption-attachment-17669">Prompt box</figcaption>

- Now, the same or different cells based on single-cell are selected and colored in range A as shown in the below figure.

### Same Values are Selected in the below image:

![Example: 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-15.png)<figcaption id="caption-attachment-17670">Example: 1</figcaption>

### Different values are selected in the below image:

![Example: 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-13.png)<figcaption id="caption-attachment-17672">Example: 2</figcaption>

## Verdict:

In this guide, you can easily understand the steps to **Compare Two Ranges to Select/Shade Duplicate or Unique Values in Excel Office 365** with **Kutools.**  Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [How to Add the Same Text or Characters in a Range of Cells in Excel 365?](https://geekexcel.com/wp-admin/post.php?post=17454&action=edit)
- [Calculate Cell Values Based on Font, Background, or Conditional Color in Excel 365!!](https://geekexcel.com/wp-admin/post.php?post=17430&action=edit)