Excel Filter by Cell Colour: Steps, Limits and Fixes

To filter by cell colour in Excel for Microsoft 365 on Windows, select a cell in your data, turn on filtering with Data > Filter (or press Ctrl+Shift+L), open the filter arrow in the relevant column, and choose Filter by Color > Filter by Cell Color, then select the colour. Excel hides rows that do not match, so you can focus on the entries marked with that fill colour.

What filtering by cell colour does

A colour filter displays rows whose cells in a chosen column have a selected fill colour. It does not change the cell contents, recolour anything, or delete rows; it temporarily hides rows that do not meet the filter. For example, if a Status column uses yellow fill for items needing review, filtering that column by yellow shows the review items while leaving the rest of the worksheet data intact.

Filtering is different from sorting. A filter narrows the visible rows to a matching group, whereas sorting rearranges rows by a chosen order, such as placing all yellow cells together. If your goal is to keep every row visible but group similar colours, use Sort by Color instead. If you need to inspect or export only a colour-coded subset, filtering is usually the more useful choice.

Prepare the data before applying a filter

Excel needs a clear column structure to filter rows reliably. Put a descriptive heading at the top of each column, keep each record on one row, and avoid blank rows or columns inside the data. A formatted Excel table is often the easiest arrangement: click in the data and use Insert > Table, or press Ctrl+T on Windows. Confirm that My table has headers is selected if the first row contains labels.

Colour should be applied to the cells in the column you plan to filter. If the colour is in the Priority column, use that column’s dropdown arrow; a red fill in a neighbouring Notes column will not make the Priority filter find the row. Before filtering, check that the colours are genuinely consistent. Two fills that look similar may be different theme colours or shades, and Excel treats distinct formatting choices as distinct colours.

For an ordinary range rather than a table, click a cell inside the data and choose Data > Filter. Excel adds dropdown arrows to the header row. If the arrows appear in the wrong row or include unrelated cells, turn filtering off, select the intended range including its headings, and turn it on again. Making the range a table can prevent this kind of boundary confusion as the data grows.

Step-by-step: filter a column by fill colour

Click any cell in the dataset or table. Make sure the range has a header row and that the target column contains the coloured cells.
If the column headings do not have filter arrows, choose Data > Filter. On Windows, Ctrl+Shift+L toggles AutoFilter for a selected range.
Open the arrow in the heading of the column whose cell fills you want to inspect.
Point to or select Filter by Color, then choose Filter by Cell Color and click the desired fill swatch.
Review the visible rows. The filter arrow normally shows a filter indicator, and the row numbers skip hidden records. The chosen colour is the criterion for that column.

The exact wording or arrangement can vary slightly with Excel updates and window size, but the colour options are in the column’s filter menu, not in the Home tab’s Fill Color palette. If the menu offers more than one kind of colour filter, select Filter by Cell Color for a fill. Filter by Font Color targets the text colour, while Filter by Cell Icon applies to icon sets created with conditional formatting.

Filter by font colour or conditional-formatting colour

Cell fill and font colour are separate formatting properties. A column might use black text on yellow fill, for instance; filtering by yellow cell colour looks at the fill, while filtering by black font colour looks at the letters. Choose the relevant option in Filter by Color rather than assuming that every visible colour in a cell is treated alike.

Excel can also filter by a colour displayed through conditional formatting, such as a red fill applied automatically when a date is overdue. Choose the displayed colour from the column’s filter menu. The underlying value remains the basis of the conditional-formatting rule, however, so the colour is a visual result rather than an independent data label. If the rule or its input values change, the displayed colours may change too; reapply the colour filter if the visible results no longer reflect the current formatting.

When colour represents an important business category, consider storing that category as text as well—for example, use a Status value of Needs review alongside the yellow fill. Text is easier to audit, filter, count, and share consistently than colour alone. It also helps readers who cannot distinguish particular colours and avoids confusion when formatting changes.

Use more than one filter and clear the results

You can filter by colour in one column and use another column’s filter to narrow the visible records further. For example, a table of service requests could be filtered to yellow cells in Priority and then to a particular owner in Assigned To. Excel combines filters across columns, so a row must meet the active criteria to remain visible. This is useful for investigating a subset without moving or deleting records.

To remove a colour filter but keep the filter arrows, open the dropdown for the filtered column and choose Clear Filter From followed by that column’s name. To clear all active filters on the worksheet, use Data > Clear. This clears filter criteria; it does not remove the cell colours or turn off the dropdown arrows. To remove the arrows, choose Data > Filter again.

If the goal is to see every row again, clearing the filter is safer than copying only the visible results over the original data. Hidden rows remain part of the worksheet while a filter is active. Before copying, printing, or making a bulk edit, check whether a filter is still applied so you know whether you are working with all records or just the visible subset.

Common problems and practical fixes

Filter by Color is missing: Confirm that filtering is enabled and that you opened a column’s dropdown, rather than a ribbon colour menu. If no cells in that column have fill colours, there may be no cell-colour option to choose.
The expected colour is not listed: Check the actual fill in the target column and look for similar but distinct shades. If the colour is produced by conditional formatting, confirm that the rule currently applies to those cells.
Rows you expect are hidden: Another column may still have an active filter. Clear all filters with Data > Clear, then apply the colour filter again. Also check that the coloured cells are in the column whose menu you used.
New or recoloured rows do not appear as expected: Make sure the new records are inside the filtered range or table. Then open the filter menu and reselect the intended colour. A table generally expands to include adjacent new rows, but a manually filtered range may not.
The filter catches only some cells that look alike: Similar appearances do not guarantee identical formatting. Inspect the fill settings or standardise the cells using one consistent colour choice, then clear and reapply the filter.

A common misconception is that a colour filter searches every cell in a row. It does not: the filter is attached to a specific column and evaluates the relevant cells in that column. Another is that filtering removes the uncoloured records. Those records are hidden temporarily and return when the filter is cleared.

Windows, Mac, and Excel for the web

These steps describe Excel for Microsoft 365 on Windows. In Excel for Mac, use the filter dropdown on the target column and look for the colour-filter options; the ribbon layout can differ, so the menu may be arranged differently. On a Mac, use Data > Filter if you need to turn filtering on and prefer not to rely on a keyboard shortcut, since shortcuts can vary with the Excel version, macOS settings, and keyboard layout.

Excel for the web also has a filter dropdown interface, but available commands and their placement can change as the web app is updated. If the colour option is absent or the menu does not offer the control you need, open the workbook in the desktop Excel app and apply the filter there. Filtering is a view of the same worksheet data, so check the active filter before assuming that a shared workbook is missing rows.

When filtering by colour is—and is not—the right approach

Colour filtering is convenient when a workbook already uses fills to mark a small number of categories and you need a quick visual review. It is especially handy for triage, quality checks, and reviewing manually highlighted exceptions. It is less dependable as the only way to classify records in a large or frequently updated dataset, because formatting can be inconsistent and does not explain what a colour means.

For recurring reports, add a data field such as Status, Risk, or Review State and filter by its values. You can still use conditional formatting to colour those values automatically. That arrangement keeps the meaning in the data while retaining the quick visual cue. It also makes it easier to build summaries or pivot-based analysis without relying on cell formatting as the category itself.

If you only need to bring matching colours together, use Sort by Color from the filter menu rather than hiding rows. If you need to search by a value such as “Overdue,” filter the text or date column directly. Choosing the method that matches the question—show only, rearrange, or find a value—reduces the chance of confusing hidden records with missing data.

Frequently Asked Questions

Can I filter by cell colour in Excel without a table?
Yes. Select a cell in a properly structured range and choose Data > Filter to add dropdowns. A formal Excel table is optional, although it can make the filter range easier to maintain as records are added.

Can Excel filter by a colour created with conditional formatting?
Yes, Excel can filter by the displayed conditional-formatting colour when that option is available in the column’s Filter by Color menu. Because the colour depends on a rule and its values, changes to the data or rule can change which rows match; reapply the filter if needed.

How do I filter by text colour instead of fill colour?
Open the arrow for the relevant column, choose Filter by Color, then select Filter by Font Color and choose the desired text colour. Do not choose Filter by Cell Color, which targets the cell fill.

Why can’t I see Filter by Color?
Check that AutoFilter is turned on and that you opened the dropdown for the column containing the formatting. The option may not appear when that column has no applicable colour formatting, and the menu can differ between desktop and web versions.

Does filtering by colour delete the other rows?
No. It hides nonmatching rows from view; their contents and formatting remain in the worksheet. Choose Data > Clear or clear the filter from the relevant column to show them again.

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.