How to Filter an Excel 2010 Table by Color

By Diane Koers

If you’ve applied color to fonts or cells in an Excel 2010 table, you can filter the table to display a subset of the data with the colors you specify. The rows that do not match the criteria you specify are hidden temporarily.

Excel 2010 tables automatically display filter arrows beside each of the column headings. To display the filter arrows so that you can filter data, format a range as a table using the Table button on the Insert tab. Or, you can click the Filter button in the Sort & Filter group on the Data tab.

1Click the filter arrow for the column by which you want to filter data.

The filter drop-down list appears.

2Point to Filter by Color in the drop-down list.

A submenu of color options appears. You can filter by Cell (background) Color or by Font Color. The submenu you see depends on the color choices in your data.

3Select an option.

Excel displays the table using the filter you requested.