How to Select Cells Based on Color/Formatting in Excel Office 365?
Tags: kutoolsexceltutorial, selectcellsbasedonco, kutools
Published: 2020-10-31 12:17:48

---
title: How to Select Cells Based on Color/Formatting in Excel Office 365?
published: true
date: 2020-10-31 12:06:32 UTC
tags: KutoolsExcelTutorial,SelectCellsBasedonCo,Kutools
canonical_url: https://geekexcel.com/how-to-select-cells-based-on-color-formatting-in-excel-office-365/
---

Here we come up with the clear-cut instructions to **Select Cells Based on Color or Formatting** in **Excel Office 365** using **Kutools.** Let’s see 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)**

**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.
## Select All Cells with Similar Formatting:

To select cells with the same formatting in an Excel spreadsheet, follow the below steps.

- Let’s consider an example of data to know how this utility works.
- In the below image, you can see the example values and some values are in **italic & bold** formatting.

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

- Go to the **Kutools Tab, click** on the **Select** option, then **choose** the **Select Cells with Format** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutool-Tab.png)<figcaption id="caption-attachment-16625">Kutools Tab</figcaption>

- It will open the **Select Cells with Format Dialog Box**.
- **Find Range –** You need to **specify the input range** using the browse button.
- Then, you need to **click** on the **Choose Format From Cell** button to select a cell that you want to use its formatting.
- **Type –** Here, all attributes of the base cell are displayed in the below list box. If you want to select all cells with the same formatting as the base cell, check all attribute options.
- **Ignore the blank cells –** You can use this option if the range has blank cells and you don’t want to select them.

![Select Cells with Format Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Cells-with-Format-Dialog-box.png)<figcaption id="caption-attachment-16626">Select Cells with Format Dialog box</figcaption>

- Then, **click** the **OK** button.
- A prompt box will pop-out to tell you how many cells will be selected from the range.
- **Click** the **Yes** button if you want to **select the cells**. Otherwise, you can **click No** option to **search again**.

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

- You can get the result as shown in the below image.

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

## Steps to Select All Cells by Color of a Cell:

If you want to select all cells based on the color of a cell from the range, do as follows.

- In the below screenshot, you can see the input cells and some of them have cell color.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-42.png)<figcaption id="caption-attachment-16630">Input Range</figcaption>

- To select cells based on the cell color, go to the **Kutools Tab, click** on the **Select** option, **choose** the **Select Cells with Format** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutool-Tab.png)<figcaption id="caption-attachment-16625">Kutools Tab</figcaption>

- It will open the **Select Cells with Format Dialog Box**.
- **Find Range –** You need to **specify the input range** using the browse button.
- Then, you need to **click** on the **Choose Format From Cell** button to select a cell that you want to use its formatting.
- **Type –** Here, all attributes of the base cell are displayed in the below list box. If you want to select all cells with the same formatting as the base cell, check all attribute options.
- **Ignore the blank cells –** You can use this option if the range has blank cells and you don’t want to select them.
- Then, **click** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-the-OK-button-9.png)<figcaption id="caption-attachment-16631">Click the OK button</figcaption>

- It will open the prompt box to show you how many cells have been selected.
- **Hit** the **OK** button to close the prompt box and see the result.
- **Click** the **Yes** button if you want to **select the cells**. You can **click No** option to **search again**.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-28.png)<figcaption id="caption-attachment-16632">Prompt box</figcaption>

- Finally, you can get the result as shown in the below image.

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

## End of the Article:

In this article, you can easily understand the steps to **Select Cells Based on Color or Formatting** in **Excel Office 365** using **Kutools. ** Give your **suggestions/feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Remove All Blank Rows from Bottom/a Range in Excel](https://geekexcel.com/remove-all-blank-rows-from-bottom-a-range-in-excel-office-365/)
- [Copy Exact Formulas without Changing Cell References in Excel](https://geekexcel.com/how-to-copy-exact-formulas-without-changing-cell-references-in-excel/)