How to Filter By Color in Google Sheets

How to Filter By Color in Google Sheets

Filtering your data by Text Color or Fill Color is very easy and straight forward to do in Google Sheets.

Consider the table below with employee names, departments, and the country they are working from.

Filtering by Color

The Departments and Countries are color-coded using conditional formatting as shown below.


To filter by color, highlight your entire data table, then go to “Create a Filter” and click on it.

Your data will have filter icons applied to every column.

To filter by Fill Color, click the filter icon in the column of interest (in our case its DEPT), then choose “Filter by Color” > Click on “Fill Color” > and select the fill color that you want.

Filter by Fill color

Your data will be filtered by the Selected fill color

To filter by text color, click on the filter icon in the column of interest (in our case it’s COUNTRY), then choose “Filter by Color” > Click on “Text Color” > and select the text color that you want.

Filter by Text

At this point, your data will be filtered by the selected text color.


Here is a quick video tutorial

You also be interest in 5 Side hustles to Monetize your Google Workspace Skills