How to Filter Cells by Background Color in Excel 365?
Tags: filtercellsbybackgro, kutools
Published: 2020-08-07 14:49:51

---
title: How to Filter Cells by Background Color in Excel 365?
published: true
date: 2020-08-06 10:50:49 UTC
tags: FilterCellsbyBackgro,Kutools
canonical_url: https://geekexcel.com/how-to-filter-cells-by-background-color-in-excel-365/
---

## Filter Cells by Background Color in Excel:

In this tutorial, we will guide you to learn the steps to **Filter Cells by Background Color in Excel** 365 using **Kutools**. We are going to use a Kutools feature that is **Special Filter** option, It will make our work simple. Let’s get into this article, and see how this feature works.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 120 built-in functions. It is used to complete the difficult tasks quickly and also in an easy method.

## Steps to Filter Cells by Background Color in Excel:

To filter cells by background-color in Excel using Special Filter function, do as follows.

- First, you need to **select a column** ( range of cells ) to filter by background color, then on the **Kutools Plus** tab, **select** the **Special Filter** option, choose the **Special Filter** option from the **drop-down** list.

![Choose Special Filter](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-9.png)<figcaption id="caption-attachment-11392">Choose Special Filter</figcaption>

- Now, it will open the **Special Filter dialog box** , You need to **select** the **Format** option, and **Choose** the **Background color** in the below drop-down list.
- **Select any color** as you need from the **right drop-down** list or **click** the given **button** to choose a color from the cell in the selected range.

![Choose the Color](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-7.png)<figcaption id="caption-attachment-11395">Choose the Color</figcaption>

- Then, you have to click the **Ok** button. It will open the **Kutools for Excel dialog box ** to tell you how many cells are found to be filtered.
- You need to click the **Ok** button to see the result.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-7.png)

- After clicking the Ok button, you will see the filtered cells like the below screenshot.

### ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-7.png)

### Additional Information:

- You can also choose the color for the text background as you need, for that, you need to open the color pallet in the Special Filter dialog box.
- Refer to the below image.

![Color Pallet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/9-2.png)<figcaption id="caption-attachment-11379">Color Pallet option</figcaption>

- Choose the color as you wish from the color pallet dialog box.

![Color Pallet dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/8-2.png)<figcaption id="caption-attachment-11378">Color Pallet dialog box</figcaption>

- You can change the **font or background color** of the filtered cells by Choosing the Font or Background color under the **Processing of results** option.
- For example, If you want to [**Filter cells by font color**](https://geekexcel.com/how-to-filter-cells-by-font-color-in-excel-365-using-kutools/), then you need to **check** the **Font color** option.

![Choose Font/Background Color](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-7.png)<figcaption id="caption-attachment-11398">Choose Font/Background Color</figcaption>

- You can also select the entire row of the resulted cells, **choose** the **Select entire row** option from the Special Filter dialog box.

![Select entire row option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6-7.png)<figcaption id="caption-attachment-11399">Select entire row option</figcaption>

## Wind-Up:

In this article, you can clearly understand the steps to **Filter Cells by Background Color in Excel** 365 using **Kutools**. Kindly, give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Create a Normal Distribution Chart (Bell Curve) in Excel?](https://geekexcel.com/how-to-create-a-normal-distribution-chart-bell-curve-in-excel/)
- [How to Update/Merge Tables By Matching Column From Two Worksheets/Workbooks in Excel?](https://geekexcel.com/how-to-update-merge-tables-by-matching-column-from-two-worksheets-workbooks-in-excel/)