In Excel, when you apply a filter to a column, you have the option to filter values based on the font color and cell background color. This option is already available in the filter, you don’t have to activate anything for this once you apply a filter.
Steps to Filter a Column by Color in Excel
- First, apply the filter to the column.
- After that, click on the filter drop-down.
- Next, go to the “Filter by Color” option.
- In the end, choose the color which you want to choose to apply the filter.
As I said, you have two ways to use color to filter values:
- By Cell Color
- By Font Color
In the following example, we have used the red font color to apply the filter. And it has filter values that have red as a font color.
In the same way, you can filter based on cell color. And in the below example, we have used the yellow cell color to filter values.
When you open the “Filter by Color”, you have the option to filter cells where you don’t have any cell color or font color.
Filter by Color from Right Click Menu
Let’s say you want to filter all the cells based on the cell color of the selected cell.
- Select the cell.
- Right-click on it.
- Go to the Filter Option.
- Click on “Filter by Selected Cell’s Color”.
In the same way, you can filter the cells based on the font color of the cell.
Use the “Filter by Selected Cell’s Font Color”.
Notes
- You can’t apply a filter based on cell color and font color at the same time on a single color. One type of filter can be used at a time.
- You can apply a filter on multiple columns based on font and cell color. For example, you can filter one column based on the red font color and filter the second column based on the yellow cell color.