Filter Excel Table by Color: Steps and Troubleshooting

Yes. In Excel for Microsoft 365 on Windows, open the filter arrow in the table column containing the colored cells, choose Filter by Color, and select a fill or font color. Excel hides rows that do not match, so the table shows records whose cells in that column have the chosen color.

What filtering by color does

A color filter is a way to display only rows whose cells in one selected column use a particular formatting color. It does not change the cell formatting or delete the hidden rows; it temporarily hides records from view, just like a text or number filter. You can still see that a filter is active from the filter icon in the column header.

The column you filter matters. If a row is colored red in the Status column but the color is in that column, choose the Status filter arrow and select red. Applying a color filter to the Owner column instead checks the color of each cell in Owner, not the color elsewhere in the row. This is useful for a table such as a task list where colors in a Priority column indicate urgent, normal, and low-priority work.

Excel can filter by cell fill color, font color, and, where available, conditional-formatting icons. The options shown depend on the formatting in the selected column. A color filter is therefore different from filtering for the text “Urgent”: color is the criterion, even if the color originally represented that text or status.

Steps to filter a table by color

First confirm the data is an Excel table with header filter buttons. Click inside the table; if it is already a table, filter arrows normally appear beside the header names. If the data is only a plain range, you can select a cell in it and use Data > Filter to add filter buttons, or convert the range to a table with Insert > Table.

Find the column containing the colored cells you want to use as the criterion.
Click that column’s filter arrow in the header. In a narrow window, the arrow may be small or appear when you point to the header.
Point to or open Filter by Color in the menu.
Choose the desired cell color under the cell-color options, or choose a font color or icon if those options are offered and relevant.
Check the visible rows and the filter icon to confirm the filter was applied.

For example, if a table has a red fill on several cells in its “Review” column, selecting that column’s arrow and then its red color displays the records with red-filled Review cells. The table’s other columns remain visible for those same records, so you can read names, dates, or amounts without changing their formatting.

On Mac, use the filter arrow in the column header and look for the same color-filter choices; the ribbon layout can differ slightly by Excel release. Excel for the web may also present a different menu or fewer options in some situations. If the color option you need is not available there, open the workbook in the desktop Excel app and check the column menu.

Filtering cells colored by conditional formatting

Conditional formatting changes a cell’s appearance according to a rule, such as filling a due-date cell red when its date has passed. Excel can expose displayed conditional-formatting colors in the color-filter choices. The exact options depend on the cells and rules in that column, so check the menu rather than assuming every color in a rule will appear.

There is an important distinction between the color and the rule that produced it. Choosing a red color filters for cells currently displayed with that color; it does not necessarily let you specify the underlying rule, such as “date is earlier than today.” If the real condition matters, use a date, number, or text filter based on the cell values instead. That makes the intent clearer and can be more reliable when rules or formatting change.

If values change and the displayed colors change while a filter is active, the visible results may not update immediately. Use Data > Reapply to reapply the current filter after edits, or clear and set the color filter again. This is especially worth checking when conditional-formatting rules depend on changing dates or formulas.

Choosing the right color option

The color menu may offer several kinds of formatting. Use the option that matches what you want to inspect:

Cell color: filters according to the cell’s background fill. Choose this when red, yellow, or green fills mark categories or review states.
Font color: filters according to the color of the characters. This is useful when the cell background is unchanged but text color carries meaning.
Icon: filters by an icon set applied to cells, when Excel offers that option. An icon set may show arrows, ratings, or other visual indicators.

Excel normally offers colors that occur in the selected column, rather than every color that could theoretically be used in a workbook. If you expect a color but cannot find it, confirm that the color is applied to cells in that column and that you opened the correct column’s menu. If the menu offers No Fill, that can be used to show cells without a fill, but it is not the same as choosing a white fill: a white-filled cell has a color, while a cell with no fill does not.

Alternating stripes from a table style can look like cell fills, but they are presentation styling rather than a dependable way to label records. Do not use banded rows as your only category marker. A dedicated status value, or an intentional fill applied to the relevant cells, gives you a clearer and more stable filter criterion.

Clear or change a color filter

To remove only one color filter, open that column’s filter menu and choose Clear Filter From followed by the column name. The rows hidden by that filter will be eligible to appear again, subject to any filters still active in other columns. To remove filters from the whole table, use Data > Sort & Filter > Clear in the Windows ribbon. Clearing a filter does not remove the colors.

To switch from one color to another, open the same column menu and select the new color. If you want all records back first, clear the filter and then choose a different color. Remember that filters can be active in multiple columns at once: a color filter in one column and a date filter in another show rows that satisfy both conditions, which can make the result look more restrictive than expected.

Common problems and how to fix them

There is no filter arrow. Click inside the table and check that the header row is enabled. If the data is a normal range, turn on filtering with Data > Filter or create a table. A protected worksheet may also limit filtering, depending on its protection settings.
Filter by Color is missing. Open the menu for the column where the color actually appears. Confirm that the cells have fill or font colors rather than only alternating table-style stripes. If working in a browser, try the desktop app if the specific option is absent.
The wrong rows remain visible. Check whether the color is in the selected column, and whether you chose cell color rather than font color or an icon. Also inspect other column headers for active filters that are narrowing the results.
A color seems inconsistent. Similar-looking colors may be different exact colors, and a conditional-formatting rule may display a color only for some values. Choose the relevant option from the menu and verify the underlying cells and rules.
New or edited records do not appear as expected. Check that the records are part of the table, then use Data > Reapply or clear and set the filter again. A new row typed directly below a table is often added to it, but confirm the table boundary if filtering does not include it.

Color filtering versus sorting by color

Filtering by color and sorting by color answer different questions. Filtering hides rows that do not match the chosen color, which is useful when you want to focus on one group. Sorting by color rearranges rows so that a selected color or icon appears in a particular order, while keeping the other rows in the list. In the column menu, use Sort by Color when you need to compare groups together without hiding the rest of the records.

Sorting can change the row order, so make sure the entire data set is part of the table before sorting. Filtering does not rearrange records; it simply hides nonmatching rows. Neither action changes the color’s meaning. If the color represents an important business status, keep that status in a text or date field as well, so the information remains understandable when colors are removed, changed, or hard to distinguish.

Alternatives when color is not a reliable criterion

Color is convenient for visual review, but it is weaker than a stored value when the category must be searched, audited, or shared. A fill color is formatting, not a normal value that a standard worksheet formula can directly inspect. For repeatable reporting, add a column such as “Status” with values like “Needs review” and “Complete,” then use the ordinary text filter. You can still apply conditional formatting to color those values automatically.

This approach avoids having to color cells manually and makes the meaning available to screen readers, exports, and other analysis tools. It also supports ordinary sorts and filters without relying on a particular shade. If the color was added manually and no category value exists, consider adding the category explicitly before using the table for decisions or sharing it with colleagues.

Frequently Asked Questions

Can I filter an Excel table by more than one color?

A color filter in one column selects one color criterion at a time. You can also apply filters to other columns, but Excel does not generally let you select several distinct fill colors as an “either color” filter in that same column. For multiple categories, use a status field or filter each color separately.

Can I filter by font color instead of cell fill?

Yes. Open the filter arrow for the column with the colored text, choose Filter by Color, and select the font-color option if it appears. Make sure the font color is actually applied in that column; a fill-color choice checks the background instead.

Does filtering by color delete or recolor rows?

No. It hides nonmatching rows from the current view without deleting records or changing their formatting. Clear the filter to show the full table again, subject to any other active filters.

Can Excel filter colors created by conditional formatting?

Excel can offer conditional-formatting colors in the color-filter menu, depending on the column’s rules and displayed results. If you need to filter by the underlying condition itself, such as a date being overdue, use a value-based filter rather than relying only on the displayed color.

Why can’t I see Filter by Color?

Check that you opened the filter menu for the column containing the colored cells and that the cells have a real fill, font color, or supported icon. Table-style banding may only be decorative. If the option is missing in Excel for the web, try the desktop app.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.