Filter by cell fill color

To filter a range by cell fill color, follow these steps:

1.Create a range of filtering.

2.Click  Sort and filter in the upper cell of the column where you want to filter the data.

3.In the window that opens, select By color filtering type. Filtering by color is available if the range has filled cells.

4.In the palette of colors available for filtering, select a fill color.

5.Click Apply.

The appearance of the sort and filter button may differ from the one shown here because it depends on whether sorting has been previously applied, the sort order (ascending or descending), and whether a filter has been previously applied:

–: No sorting or filtering applied.

–: Filter applied, no sorting applied.

–: Sorted in ascending order with no filter applied.

–: Sorted in descending order with no filter applied.

–: Sorted in ascending order with filter applied.

–: Sorted in descending order with filter applied.