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!
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.
The icon is near the end of the main toolbar.
Inverted triangles, a symbol for the filter feature in Google Sheets, will appear on the cells of the header row or the first row.
A green box will appear when you hover your cursor over the icon.
A drop-down box will appear. Click Filter by color. Another drop-down box will appear afterwards.
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.
Only the light blue filled rows will remain:
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.
The icon is near the end of the main toolbar.
Inverted triangles, a symbol for filter command in Google Sheets, will appear on the cells of the header row or the first row.
A green box will appear when you hover your cursor over the icon.
A drop-down box will appear. Click Filter by color. Another drop-down box will appear afterwards.
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.
Only the rows with red berry colored text will remain:
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.
