Filter by font color, cell color, or icon sets in Excel 2016 for Mac

You can quickly filter data based on visual criteria, such as font color, cell color, or icon sets. And you can filter whether you have formatted cells, applied cell styles, or used conditional formatting.

Note: Some of the content in this topic may not be applicable to some languages.

Filter data by visual criteria

  1. In a range of cells or a table column, click a cell that contains the cell color, font color, or icon that you want to filter by.

  2. On the Data tab, click Filter.

    On the Data tab, select Filter

  3. Click the arrow AutoFilter arrow in the column that contains the content that you want to filter.

  4. Under Filter, in the By color pop-up menu, select Cell Color, Font Color, or Cell Icon, and then click the criteria.

    Example of filtering by cell color

See Also

Highlight patterns and trends with conditional formatting

Filter a list of data

Apply, create, or remove a cell style

Filter by font color, cell color, or icon sets

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!