Filter Cells by Color in Excel: Steps and Tips

To filter cells by color in Excel for Microsoft 365 on Windows, select your data, choose Data > Filter, open the arrow in the column you want to filter, then choose Filter by Color and select a fill color, font color, or available icon. Excel hides rows that do not match; it does not change or delete their contents.

What filtering by color does

Excel’s color filter is a way to show records whose cells have a particular visual format. For example, if a Status column uses a yellow fill for items awaiting review, you can filter that column to show only yellow cells. The rest of the table remains in the worksheet but is temporarily hidden by the filter.

This is different from sorting by color. Filtering narrows the visible records to a chosen color. Sorting by color rearranges records so cells with a chosen color appear together, while other colors remain visible. Both commands are available from a column’s filter menu, but they solve different problems.

A color is not a data value. A red cell does not automatically mean overdue to Excel, and changing the text in the cell does not necessarily change its formatting. Color filters are useful for reviewing a visually coded list, but they are less dependable than filtering a real status field when color is the only place a category is recorded.

Steps to filter by cell color

Check that the data has a header row, such as Product, Status, and Owner. Avoid blank rows or columns inside the list because they can make Excel detect only part of the data.
Click a cell in the data range. If Excel does not identify the full range correctly, select the complete range, including its headers.
Choose Data > Filter. On Windows, Ctrl+Shift+L toggles the filter arrows on or off. If your data is an Excel table, the arrows normally appear in its header row already.
Open the filter arrow in the column containing the color you want to use. Choose Filter by Color, then choose the color shown in the menu. Depending on the formatting present, the menu may offer cell color, font color, or a conditional-formatting icon.
Check the visible rows and the filter indicator in the column header. To restore all rows, open that column’s arrow and choose Clear Filter From [column name]. To remove the arrows themselves, choose Data > Filter again.

For instance, imagine a task list with a blue fill in the Priority column for urgent tasks. Choosing that blue under Filter by Color displays the rows whose Priority cells have that fill. The filter does not infer urgency from the word in another column; it looks at the formatting of the selected column.

Filtering fill color, font color, and icons

Filter by Color can work with more than a cell’s background fill. If the column contains differently colored text, Excel may offer Filter by Font Color. If conditional formatting uses icon sets, such as traffic-light symbols or arrows, the menu may offer Filter by Cell Icon. Options depend on the formatting used in that column, so a menu will not show every option in every worksheet.

Excel can also apply color through conditional formatting rather than through a manually chosen fill. When the displayed color is available in the filter menu, you can select it there. This is handy for rules such as highlighting late dates or high sales. Remember that the rule determines the appearance; the filter still selects rows based on the color shown in the chosen column, not on the rule’s explanation or the underlying business meaning.

Cells with no fill may be available as a color choice when the column has filled cells. If you want to show uncolored records, look for a no-fill or equivalent option in the color menu. The exact labels can vary with the colors and formatting present.

Using color filters in tables and larger lists

Excel tables are often easier to manage than ordinary ranges because their header filters stay attached as the table expands. To turn a range into a table, select it and choose Insert > Table, then confirm whether the range has headers. A table does not change what color filtering means, but it can make filter controls and newly added records more predictable.

Filters on separate columns can be combined. For example, you can show rows with a red Status cell and then use the Owner filter to show only one person’s records. Excel displays only rows that satisfy the active filters together. If the result seems unexpectedly small, check the arrows in every header: a filter left on another column may be narrowing the list as well.

In one column, the color filter is generally used to select a particular available color at a time. If you need several colors at once, do not assume that choosing a second color will add it to the first selection; applying another filter can replace the existing criterion for that column. A helper field with explicit categories is usually clearer for selecting multiple groups.

When a color filter is not enough

Color is most useful when it is a visual aid alongside meaningful values. If yellow means Waiting and green means Complete, storing those words in a Status column lets you filter by the actual category, sort consistently, create summaries, and use the same data in charts or other tools. A color can still be applied to the status cells with conditional formatting, but the label remains the source of truth.

Consider a sales sheet where red fill marks low-performing products and green fill marks strong ones. If the threshold is based on sales, filter the numeric Sales column using a number condition instead of relying only on fill. That way a changed threshold does not leave old colors misleadingly in place. If the colors were assigned manually, a helper column containing the reason for each color also makes the data easier to audit.

For a one-time review of a small list, filtering by color is quick and practical. For a recurring report, shared workbook, or workflow where decisions depend on the category, use a value such as Review, Approved, or Overdue and treat color as a secondary cue. This avoids ambiguity when someone changes a format, copies a cell, or views the workbook with different display settings.

Common problems and how to fix them

The filter arrows are missing: Click inside the data and choose Data > Filter. Confirm that the first row contains headers. If the list is separated by blank rows or columns, select the intended range before turning on filtering.
Filter by Color is unavailable: The selected column may not contain the kind of cell, font, or icon formatting that Excel can filter. Open the arrow for the column that actually displays the color, not a neighboring field. If needed, apply a consistent fill or use a text category instead.
Some expected rows do not appear: Check for similar but different shades, cells with no fill, or a second filter in another column. A copied color can look identical on screen while having a different formatting value. Choose the exact color offered in the menu.
The visible color changes but the results seem stale: This can happen after editing values that drive conditional formatting or changing cell formats while a color filter is active. Clear the color filter, let the formatting update, and apply the intended color filter again.
Rows appear to be gone: Filtering hides nonmatching rows; it does not delete them. Clear the filter to reveal the full list. Be careful when copying or editing a filtered range, because only visible records may be selected by some actions.

Excel for Mac and Excel for the web

The main desktop workflow is similar in Excel for Mac: use the Data tab’s Filter command, then open the relevant column menu and look for the color filter options. Keyboard shortcuts can differ by Mac version, keyboard settings, and Excel build, so the ribbon command is the dependable alternative to the Windows Ctrl+Shift+L shortcut.

Excel for the web has filter controls, but its menus and available formatting options can differ from the Windows desktop application. If a color option you need is missing, open the workbook in the desktop version of Excel and try the column menu there. A workbook may also be edited by several people using different versions, so a value-based status column is a more portable way to preserve the meaning of categories.

Frequently Asked Questions

Can I filter by more than one color in Excel?
Excel’s color filter for a column is designed to select a color, rather than build a multi-color selection in the same way as checking several text values. For several categories, add a status field and filter that field, or use a separate helper column to group the colors you need.

Can Excel filter by conditional formatting color?
It can offer displayed conditional-formatting colors or icons in the column’s Filter by Color menu when those options are available. If the rule changes the appearance as values change, clear and reapply the filter after relevant edits if the displayed results no longer match what you expect.

Does filtering by color delete the other rows?
No. It hides rows that do not match the selected color. Use Clear Filter From the column menu, or clear the active filters, to display the full data again.

Can I filter by font color instead of fill color?
Yes, when the column contains font colors Excel offers in its Filter by Color menu. Open the filter arrow for that column and choose the desired font color option.

Why can’t I see Filter by Color?
The selected column may not have filterable color formatting, or you may have opened the menu for a different column. Check the cells and formatting in the target column; if color is not a reliable category, use an explicit text or numeric field instead.

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.