How to Filter Cells By Font Color in Excel 365? – Using Kutools
Tags: filtercellsbyfontcol, kutools
Published: 2020-08-06 10:10:38

---
title: How to Filter Cells By Font Color in Excel 365? – Using Kutools
published: true
date: 2020-08-05 12:07:43 UTC
tags: FilterCellsbyFontCol,Kutools
canonical_url: https://geekexcel.com/how-to-filter-cells-by-font-color-in-excel-365-using-kutools/
---

## Filter Cells By Font Color in Excel:

In this article, you will learn the steps to **Filter Cells By Font Color in Excel** 365 using **Kutools**. Because Kutools has a special feature of **Special Filter** function to do this task quickly. Let’s see how it 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. These features will help you to solve the complicated work easily. 

## Jump To:

- **[Steps to Filter Cells By Font Color in Excel ](#1)**
- **[Closure](#2)**

## Steps to Filter Cells By Font Color in Excel:

To filter cells by font color using Special Filter option in Excel, do as follows.

- First, you need to enable the **Special Filter** feature. On the **Kutools Plus** tab, Select the **Special Filter** option, then choose **Special Filter** from the drop-down list.

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

- It will open the **Special Filter** dialog box.
- Now, You have to **Select the Column** you want to filter cells by font color.
- **Check** the **Format** option and **Choose** the **Font color** option from the **drop-down** list.
- **Select** any **one** of the colors listed in the right drop-down list to be filtered. ( Use the given icon to select the color)

![Special Filter Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-6.png)<figcaption id="caption-attachment-11365">Special Filter Dialog Box</figcaption>

### Note:

If you want to choose the color as you need, use the color palette in the drop-down list. 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>

Here is the color pallet image for your reference. ( Use this to choose your desired color )

![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>

- Hit the **Ok** button. Kutools for Excel dialog box will be popped out to tell you how many cells are found to be filtered.
- Click the **Ok** button.

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

- Then, the filtered cells are displayed in the spreadsheet with the specified font color as the below screenshot.

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

### Note:

- You can also specify the Background Color of the filtered cells by selecting the **Background color** from the drop-down list under the **Processing of results** section(1).
- If you want to **select the entire row** of the filtered cells, choose the Select entire row option in the **Special**  **Filter** dialog box(2).

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

## Closure:

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

### Keep Reading:

- [How to Filter Cells by Workday/Weekend/Specific Day of the Week in Excel?](https://geekexcel.com/how-to-filter-cells-by-workday-weekend-specific-day-of-the-week-in-excel/)
- [How to Filter All Cells By Italics in Microsoft Excel 365?](https://geekexcel.com/how-to-filter-all-cells-by-italics-in-microsoft-excel-365/)