Excel Table Filter by Multiple Colors: What Works

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, a table’s color filter can show rows for one selected fill color, font color, or icon in a column at a time; it cannot include several colors in that same color-filter rule. To show several color groups together, filter by the underlying values instead, or add a helper column that labels the groups and filter that column.

That distinction matters because a colored cell is formatting, not usually a data value Excel can combine with ordinary filter checkboxes. The most reliable solution is to make the reason for each color available as a value—such as a status, category, or priority—and filter those values. If colors were applied manually and have no consistent meaning in the data, there are still workarounds, but they require more upkeep.

What filtering by color does

Excel’s color filter limits visible table rows according to the appearance of cells in the column whose filter menu you opened. For example, if the cells in a Priority column have red, yellow, and green fills, you can filter that column to show rows whose Priority cell has a chosen fill. The filter hides nonmatching rows; it does not delete them.

Color filtering is different from selecting several text values in a regular filter menu. With a text or number filter, you can often tick multiple listed values and show them together. The color-filter submenu is a choice of a particular color, font color, or conditional-formatting icon—not a checklist for selecting several colors in one column.

The filter applies to the column’s cells, not to any colored cell anywhere in the row. If a row has a red cell in Notes but the filter is opened for Status, Excel evaluates the Status cell’s color. That can surprise people who use color as a general visual marker across several columns.

How to filter a table by one color

  1. Click a cell in the Excel table. Confirm that the header row has filter arrows. If necessary, turn on filtering from Data > Filter.
  2. Open the dropdown arrow in the header of the column containing the colored cells.
  3. Point to Filter by Color, then choose the relevant cell color, font color, or icon option shown in the menu.
  4. Check the visible rows and the filter indicator in the header. To remove the restriction, use the header menu’s clear-filter command, or choose Data > Clear to clear filters across the range.

For an Excel table, the header dropdown is the most direct route. The Data tab’s filter controls can also turn filtering on or clear filters, but the choice of a particular color is made from the column dropdown. Menu options can vary with the colors and icons actually present in that column.

In Excel for Mac, use the table header dropdown in the same way; ribbon placement and some menu details can differ from Windows. Excel for the web may present controls differently, so check the column dropdown for a color-filter option if you are working in a browser. If it is not offered in your version, use the value-based approach below or open the workbook in desktop Excel.

Can one column be filtered by multiple colors?

Not as a single color filter. Choosing a second color in the same column replaces the first color criterion rather than adding an OR condition. For example, filtering a Status column first for red and then for yellow does not produce a view containing both red and yellow rows; the resulting color filter is for the selected color.

You can apply filters to more than one column at once, but filters on different columns normally narrow the results together: a row must meet each active column’s condition. That is useful when you want, for example, red in one column and blue in another. It does not provide an OR rule that means “red or yellow in this one column.”

Sorting by color is another feature, but it is not a substitute for a multi-color filter. A color sort groups or orders rows by a selected color while leaving other rows in the table; a filter hides rows that do not meet its condition. You can use sorting to inspect color groups, but it will not create a view containing only a chosen set of colors.

Best option: filter the values behind the colors

If colors communicate categories such as Open, Waiting, and Complete, store those categories as text in a Status column and use formatting to display each status in a distinct color. Then filter Status by selecting multiple values in the dropdown checklist. This gives you the equivalent of including several color groups, while keeping the data meaningful to people and to Excel’s other tools.

For example, suppose a task table has 200 rows. The Status values are Open, Waiting, and Complete, and conditional formatting displays them in red, yellow, and green. To show Open and Waiting together, open the Status filter, clear (Select All), tick Open and Waiting, and apply the filter. Excel shows both categories because the filter operates on the text values, not on the colors.

This design also makes the workbook easier to sort, summarize, search, and share. A colleague can understand the category even in a printout or a display where color is hard to distinguish. If the color scheme changes later, the underlying values and filters remain useful.

  • Use a dedicated field such as Status, Risk, or Review group to record the category.
  • Apply consistent conditional formatting rules based on that field, rather than coloring cells ad hoc.
  • Filter by one or more category values when you want a combined view.
  • Keep the color legend visible if readers need to interpret the formatting.

Using a helper column for color groups

A helper column is useful when the rows need a practical grouping field but the existing data does not have one. Add a column such as Color group and enter a label—Red group, Yellow group, or Review—beside each row. You can then filter that helper column by multiple labels using its value checklist. In a table, a new column is included in the table when added directly next to it, and the filter dropdown can be used like the other headers.

Be clear about what the helper labels represent. A label entered manually can become out of date if someone changes a cell’s fill but forgets to update the helper. To prevent mismatches, make the helper value the source of truth and apply the fill from that value with conditional formatting. If the table already uses a status or category field, use that field rather than maintaining a duplicate label.

A worksheet formula cannot generally inspect a cell’s fill color as an ordinary value. Functions such as IF and COUNTIF evaluate cell contents and conditions, not arbitrary manual formatting. That is why adding a formula that tries to test whether a cell “is red” is not a dependable way to classify manually colored cells. Use a real category field, or a purpose-built macro if the workbook genuinely must act on formatting.

Conditional formatting and color filters

Color may come from a direct fill chosen on the Home tab, or from a conditional formatting rule that changes a cell’s appearance when its value meets a condition. Excel’s color-filter options can include colors displayed by conditional formatting, as well as direct cell formatting, when those options are available in the column menu. The underlying rule is still a better filter target when you need several categories at once.

For instance, imagine that a Due date column turns red when a task is overdue and yellow when it is due soon. Instead of trying to combine those two displayed colors, add or use a Status field such as Overdue, Due soon, and Not due soon. Filter the field for the first two values. This makes the intended OR condition explicit and avoids relying on how the visual formatting is rendered.

Conditional formatting can also be based on formulas or rules that change as data changes. If you edit the rule, a color that previously identified one group might no longer mean the same thing. Filtering on the underlying condition or category avoids treating appearance as permanent data.

When colors were applied manually

Manual fills are common in review spreadsheets, but they are the hardest case because the color may not be recorded anywhere else. First decide whether the colors have a stable meaning. If red means “needs correction” and yellow means “check later,” create those labels in a helper or status column and filter the labels. This is usually safer than trying to collect visible rows by color each time.

If the colors are temporary marks and you only need a one-off view, filter the column for one color, copy the visible rows to a separate worksheet, and repeat for the other desired color. Keep the source data intact and label the copied results. This is a manual snapshot, not a live combined filter: later edits to the source table will not automatically update the copied list.

For recurring workbooks, VBA can inspect formatting and automate a custom process, but it adds complexity, may be restricted by security settings, and needs maintenance. A macro also cannot be undone with Ctrl+Z. Save a copy before running one, and prefer a normal data field whenever the color corresponds to a business category.

Common problems and checks

  • No Filter by Color option: Confirm that the chosen column contains cells with distinguishable colors or icons and that you opened that column’s header menu. Client or build differences can affect which options are shown.
  • The wrong rows remain visible: Check the color of the cells in the filtered column, not other cells in the same rows. Also check for other active filters, which may further narrow the table.
  • Only one color appears: That is the expected limit for a color-filter criterion in one column. Use a value field or helper labels to include several groups.
  • Some cells seem to have the same color: Similar shades may be different colors, and conditional formatting may change the displayed appearance. Standardize the rules or filter the values that trigger them.
  • Rows appear missing after clearing a filter: Clear filters on the relevant table columns, and check whether rows are hidden for another reason, such as a separate filter or manual hiding.

It is also worth checking whether the table has a consistent range and a proper header row. If data was pasted outside the table, those rows may not be included in the table’s filter at all. Resize the table or add the records inside its range before judging the filter result.

Choosing the right method

Use the color filter when the goal is a quick view of one color group in one column. Use value filters when you need several groups together, when colors stand for categories, or when the result should update reliably as the table changes. Use a helper column when the category is not currently represented in the data. Reserve manual copy-and-combine steps for one-time tasks, and macros for workflows that truly require automation based on formatting.

A useful rule is to ask whether the color is the data or merely a signal about the data. If the color communicates a real fact—approval state, urgency, or ownership—store that fact in a field and let formatting reinforce it. If the fill is only a temporary visual annotation, a one-color filter may be enough for inspection, but a multi-color workflow will be more dependable when the annotations are converted into explicit labels.

Frequently Asked Questions

Can I select two fill colors in an Excel table filter?
No. The color filter applies one selected color in that column at a time. To show two groups together, filter by their underlying text or number values, or create a helper column with group labels and select both labels.

Can I filter by font color instead of cell fill?
Yes, when the column’s dropdown offers the option. Open the header menu, point to Filter by Color, and choose a font color. This is still a single-color filter, so it does not combine several font colors in the same column.

Can Excel formulas detect a manually applied fill color?
Ordinary worksheet formulas do not evaluate a cell’s manual fill as a normal value. Record the category in a cell and filter that value, or use a macro only if a formatting-based process is essential.

Does filtering by color delete or change the table data?
No. It hides rows that do not match the chosen color; clearing the filter makes the rows visible again. A filter changes the view, not the cell contents.

Can I filter by color when the color comes from conditional formatting?
Excel can offer displayed conditional-formatting colors in the color-filter menu. For a view containing multiple conditional-formatting categories, filtering the values or conditions behind the rules is more dependable than trying to combine colors.

Related

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.