See all How-To Articles

How to Filter by Color in Excel & Google Sheets

In this tutorial, you will learn how to filter data by color in Excel and Google Sheets.

 

google sheets filter by color final data

 

Filter by Color

Say you have the formatted data set shown below and want to filter and only display those rows highlighted in green.

 

filter by color initial data

 

  1. First, turn on the filter. Click anywhere in the data range (e.g., B2:G16) and in the Ribbon, go to Home > Sort & Filter > Filter.

 

turn filter on

 

  1. Click on the filter button next to any of the column headings (B2, for example), go to Filter by Color, and choose green.

 

filter by color excel

 

As a result, only rows with cells colored in green are displayed (3, 4, 10, and 16) while all other rows are hidden.

 

filter by color excel 2

 

Filter by Color in Google Sheets

  1. To create a filter, click anywhere in the data range (B2:G16) and in the Menu, go to Data > Create a filter.

 

google sheets create a filter

 

  1. Click on the filter button next to any of the column headings (B2, for example). Then go to Filter by color > Fill Color and choose green (#A9D08E).

 

google sheets filter by color

 

The result is the same as in Excel: All green rows are displayed.

 

google sheets filter by color 2