In this article:

How to Filter by Color in Google Sheets (The Easy Way!)

In this article we will show you how to filter by color in Google Sheets in just a few simple clicks, either by the fill color or by the text color. Just follow the steps below!

Filter by Fill Color in Google Sheets 

1. Click any cell in the table

You can even select the whole table in this step; however, Google Sheets can automatically detect the bounds of your table. You will notice this when you do the next step.

Google sheets filter by color, filter by fill color, select table cell

2. Click Create a filter icon along the main toolbar

The icon is near the end of the main toolbar.

filtered by color in Google sheets  - create a filter

Inverted triangles, a symbol for the filter feature in Google Sheets, will appear on the cells of the header row or the first row.  

Google sheets filtering by color, filter icon added to header row

3. Click the inverted triangle icon on the header cell of one of the columns with a fill color

A green box will appear when you hover your cursor over the icon. 

filter by colors in google sheets - cursor over filter icon

4. Select Filter by color

A drop-down box will appear. Click Filter by color. Another drop-down box will appear afterwards. 

Google sheets filter by color, option from drop-down box

5. Select the Fill Color to filter

Select Fill color, then select the color you want to filter. The names assigned by Google Sheets to each color will be set as the label for the color choices. For this example, we select light blue 3.

Google sheets filter by fill color -  options from drop-down box

Only the light blue filled rows will remain:

Google sheets filter by color - only light blue colored rows remain

Filter by Text Color in Google Sheets 

1. Click any cell in the table

You can even select the whole table in this step; however, Google Sheets can automatically detect the bounds of your table. You will notice this when you do the next step.

Google sheets filter by color, filter by text color, select table cell

2. Click Create a filter icon along the main toolbar

The icon is near the end of the main toolbar.

Google sheets filter cell by color of text, create a filter icon

Inverted triangles, a symbol for filter command in Google Sheets, will appear on the cells of the header row or the first row.  

Google sheets filter by colour - filter icon added to header row

3. Click the inverted triangle icon on the header cell of the column with the text color

A green box will appear when you hover your cursor over the icon. 

filter by color of text, cursor over filter icon

4. Select Filter by color

A drop-down box will appear. Click Filter by color. Another drop-down box will appear afterwards. 

Google sheets color filter, filter by text color option from drop-down box

5. Select the Text color to filter

Select Text color, then select the color you want to filter. The names assigned by Google Sheets to each color will be set as the label for the color choices. For this example, we select red berry.

filter text by color, text color options from drop-down box

Only the rows with red berry colored text will remain:

Google sheets filter by text color, only rows with red berry colored text remain

Use our tax calendar software to easily set up custom reminders from your spreadsheet in just a few clicks. 

If you enjoyed this article, you might also like our article on how to create filter views in Google Sheets or our article on how to add numbers in a column in Google Sheets. 

If you want to learn how to send emails based on dates in Google Sheets, we also suggest checking out our detailed guide. 

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started