Compare Two Ranges of Cells If they are Equal or Different in Excel 365!
Tags: kutoolsexceltutorial, stepstocomparetworan, kutools
Published: 2020-09-30 08:46:54

---
title: Compare Two Ranges of Cells If they are Equal or Different in Excel 365!
published: true
date: 2020-09-29 12:15:54 UTC
tags: KutoolsExcelTutorial,StepstoCompareTwoRan,Kutools
canonical_url: https://geekexcel.com/compare-two-ranges-of-cells-if-they-are-equal-or-different-in-excel-365/
---

## Compare Two Ranges of Cells If they are Equal or Different in Excel:

In this article, you will understand how to **Compare Two Ranges of Cells If they are Equal or Different in Excel Office 365 using 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 of Cells If they are Equal:

To compare two ranges of cells if they are equal, do as below instructions.

- In the below screenshot, you can see the **two ranges** ( **A & B** ) of date, and we are going to compare them. Then, find the cells which are equal.

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

- Go to the **Kutools Tab, select** the **Range** option, and **choose** the **Compare Cells** option from the menu.

![Choose Compare Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Compare-Cells-option.png)<figcaption id="caption-attachment-14779">Choose Compare Cells option</figcaption>

- It will open the **Compare Cells dialog**   **box. **
- In that dialog box, you need to **select the two ranges ( A & B )** by using the “ **Find Values in** “ **box** and “ **According to** “ **box**.
- Then, you need to choose the **Same Cells** option under the **Find** section.
- If you want to highlight the equal cells with a specific **background color** or **font color,** you can use **Fill backcolor** and **Fill Font color** options under the **Processing of Results section.**
- You can also **select** the **Case Sensitive** option.
- Now, hit the **OK** button.

![Compare Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Compare-Cells-dialog-box.png)<figcaption id="caption-attachment-14780">Compare Cells dialog box</figcaption>

- After clicking the Ok button, **Kutools for Excel dialog box** will pop out to tell you how many cells have been found. Then, **click** the **OK** button to close the dialog box.

![Kutools for Excel dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Kutools-for-Excel-dialog-box-2.png)<figcaption id="caption-attachment-14781">Kutools for Excel dialog box</figcaption>

- Now, you can see all the equal cells in **range A** have been highlighted with the specified background color and font color based on the cell values in **range**  **B**.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-15.png)<figcaption id="caption-attachment-14782">Result</figcaption>

## Compare Two Ranges of Cells If they are Different:

If you want to compare two ranges of cells to find different values, follow the below steps.

- In the below screenshot, you can see the **two ranges** ( **A & B** ) of date, and we are going to compare them. Then, find the cells which are equal.

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

- Go to the **Kutools Tab, select** the **Range** option, and **choose** the **Compare Cells** option from the menu.

![Choose Compare Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Compare-Cells-option.png)<figcaption id="caption-attachment-14779">Choose Compare Cells option</figcaption>

- It will open the **Compare Cells dialog**   **box. **
- In that dialog box, you need to **select the two ranges ( A & B )** by using the “ **Find Values in** “ **box** and “ **According to** “ **box**.
- Then, you need to choose the **Different Cells** option under the **Find** section.
- If you want to highlight the equal cells with a specific **background color** or **font color,** you can use **Fill backcolor** and **Fill Font color** options under the **Processing of Results section.**
- You can also **select** the **Case Sensitive** option.
- Now, hit the **OK** button.

![Compare Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Compare-Cells-dialog-box-1.png)<figcaption id="caption-attachment-14783">Compare Cells dialog box</figcaption>

- After clicking the Ok button, **Kutools for Excel dialog box** will pop out to tell you how many cells have been found. Then, **click** the **OK** button to close the dialog box.

![Kutools for Excel dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Kutools-for-Excel-dialog-box-1-1.png)<figcaption id="caption-attachment-14784">Kutools for Excel dialog box</figcaption>

- Now, you can see all the different cells in **range A** have been highlighted with the specified background color and font color based on the cell values in **range**  **B**.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-1-1.png)<figcaption id="caption-attachment-14785">Result</figcaption>

## Summary:

In the above article, you can learn the steps to **Compare Two Ranges of Cells If they are Equal or Different in Excel Office 365 using Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Password Protect a Sheet in Excel Office 365?](https://geekexcel.com/how-to-password-protect-a-sheet-in-excel-office-365/)
- [Add Hours/Minutes/Seconds to a Datetime in Excel Office 365!!](https://geekexcel.com/add-hours-minutes-seconds-to-a-datetime-in-excel-office-365/)