Filter in Excel by Cell Color: A Step-by-Step Guide

Formulas & functions · Updated November 20, 2026

To show only rows with a particular fill color in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the filter arrow in the column you want to check, then choose Filter by Color and select the cell color. Excel hides rows that do not match, so you can focus on color-coded records without changing or deleting the underlying data.

What You’ll Need

  • An Excel workbook containing a list or table with a header row and at least one column of colored cells.
  • Colors applied as cell fill, either manually or through conditional formatting. Excel can filter by displayed fill color, but it does not interpret what a color means; you choose the color to show.
  • Permission to edit or filter the workbook. If the sheet is protected, filtering may be unavailable unless the owner allowed it.

Filtering works best when each row represents one record, such as an order, task, or person, and each column has a single type of information. A header row makes it easy to identify the right column. Save a copy first if you are unfamiliar with the workbook or may need to preserve its current view; filtering itself does not remove rows.

Step-by-Step

  1. Check the data layout. Make sure the colored cells belong to a clearly defined list with one header row, such as Status, Owner, and Due Date. Avoid blank rows or columns inside the list because Excel may treat them as the edge of the data. If there is a title or explanatory note above the headers, leave it outside the data range.
  2. Select a cell in the list. Click any populated cell in the range you want to filter. You usually do not need to drag over the entire list: Excel can detect a continuous data region from the active cell. If there are adjacent unrelated values, or a blank row splits the list, select the exact range, including its headers, before turning on filtering.
  3. Turn on the filter controls. On the Windows ribbon, choose Data > Filter. Excel adds a drop-down arrow to each header cell in the detected range. You can also use Home > Sort & Filter > Filter. If the arrows were already visible, filtering is on and you can move to the next step. If the selected range is formatted as an Excel table, filter arrows are normally present by default.
  4. Open the menu for the color column. Click the arrow in the header of the column whose cell fills you want to filter. For example, if task priority is indicated by colored cells in the Priority column, open that column’s arrow. Do not use the arrow from an unrelated column just because it is nearby; the color choices apply to the selected column.
  5. Choose the color filter. Point to or select Filter by Color in the menu. If Excel recognizes fill colors in that column, choose the desired shade under Filter by Cell Color. The menu may also offer Filter by Font Color or Filter by Cell Icon when those kinds of formatting are present. Choose the cell-color option for background fills, not the font-color or icon option.
  6. Check the filtered results. Excel hides rows whose cells in that column do not have the selected fill. Read the visible records and check the column header for a filter indicator, which shows that a filter is active. The row numbers may skip because hidden rows remain in the worksheet. They have not been deleted or moved.
  7. Add another condition if needed. To narrow the visible results further, open the filter arrow in another column and set a second filter, such as a text or date condition. Excel combines filters across columns: a row must meet the conditions in each filtered column to remain visible. To show two fill colors from the same column, Excel’s basic color-filter menu generally lets you select one cell color at a time. A practical alternative is to filter the colors separately, or add a helper category column and filter that column by its text values.
  8. Clear the filter when you are finished. To restore rows hidden by the color choice, open the arrow in that column and select Clear Filter From followed by the column name. To clear every active filter at once, choose Data > Clear. The filter arrows can remain in place. To remove them, choose Data > Filter again; removing the arrows does not delete data or necessarily restore a previously filtered view, so clear filters first if you want all rows visible.

Example: Suppose a project tracker has Task, Owner, and Status columns, and the Status cells use green fill for complete tasks and yellow fill for tasks in progress. Turn on filtering, open the Status arrow, then choose Filter by Color > Filter by Cell Color > the green swatch. Excel displays the complete tasks and hides the other rows. If you then filter the Owner column to one person, the visible results show only that person’s complete tasks. Clear the Status filter to see that person’s tasks in every status.

On Excel for Mac, the same basic workflow applies: use Data > Filter, then open the column’s filter menu and choose the color option. Ribbon layout and menu presentation can differ slightly by release. Excel for the web also has filter menus, but available options may vary with the workbook and browser version; if the color command is missing, open the workbook in the desktop app. These instructions concern filtering rows by fill color, not sorting rows into color order.

Common Mistakes

  • Choosing a font color instead of a fill color. A red font and a red cell background are separate formatting properties. In the menu, select Filter by Cell Color when the background is what identifies the records.
  • Opening the wrong column’s menu. Color filtering checks cells in the column whose arrow you open. If color coding is in Status, filtering the Owner column by color will not find the Status fills.
  • Expecting a filter to delete or rearrange records. A filter hides nonmatching rows temporarily. It is not a deletion, and it does not sort the records. Clear the filter to reveal the hidden rows again.
  • Filtering only part of a list. A blank row, blank column, or unrelated adjacent data can cause Excel to identify the wrong range. Check that filter arrows appear on every intended header and that no relevant rows are outside the filtered area.
  • Assuming similar shades are identical. A light green and a darker green can be treated as different colors. Choose the exact swatch shown in the filter menu, and remember that a theme color, a custom RGB color, and a visually similar shade may not match.
  • Expecting one color selection to include several fills. The standard color filter applies a chosen color, rather than a flexible group of several colors in the same column. If the workflow depends on grouping multiple colors, use a consistent category in a separate column instead.

Tips

  • Use color consistently. Choose a single fill for each meaning and apply it uniformly. A legend near the data can remind colleagues what each color represents, but the legend should sit outside the filtered list so it does not become a record.
  • Prefer a status value as well as color. A text label such as Complete or In Progress is easier to search, filter, share, and interpret for people who cannot distinguish the colors. Color can reinforce the label rather than being the only place the information is stored.
  • Use an Excel table for a growing list. Select the data and choose Insert > Table, confirming that the table has headers. Tables include filter controls and usually expand when you add rows directly below them. Check the table’s boundaries if newly added records do not appear in a filter.
  • Keep conditional formatting in mind. A cell may look colored because a conditional-formatting rule is currently true, rather than because someone applied a permanent fill. The filter works with the displayed color in supported desktop versions, but the available color choices depend on formatting present in that column. If the rules change, the visible color and matching rows can change too.
  • Consider sorting by color when order matters. Filtering keeps only matching rows visible; sorting by color reorders rows while keeping them in the list. Look for Sort by Color in the sort menu if you want to group colors but retain all records. Choose the option that matches whether you want to hide rows or change their order.
  • Check for hidden records before sharing. A workbook can be saved with a filter active, so another person may open it and see only part of the list. Clear filters before distributing the file if you want the complete dataset to be visible by default.

Troubleshooting

Filter by Color is missing or unavailable: Confirm that you opened a filter arrow in a column containing colored cells and that filtering is enabled. If the column has no recognized fill colors, Excel may not show a cell-color choice. Check whether the color is actually font color, an icon, or conditional formatting. If the sheet is protected, ask the workbook owner whether filtering is allowed or whether protection can be adjusted.

The expected color does not appear in the menu: Click a cell that visibly has that fill and inspect its formatting. The color could be applied by a conditional-formatting rule, could be a slightly different shade, or may be in another column. Try selecting a cell with the exact appearance and reopen the correct column’s menu. If the display comes from a complex rule, test the filter in the current desktop version and consider using a text status field for dependable grouping.

Some matching rows are missing: Check for inconsistent shades and verify that the missing rows are inside the filtered range. Look for blank rows that split the data, a table that did not expand, or a second active filter in another column. Choose Data > Clear to remove all filter criteria, then apply only the color filter again. If some cells have no fill while others use white fill, do not assume they are the same formatting state; check the menu’s available choices.

Rows seem to have disappeared: Look at the row numbers and the filter indicators in the headers. Skipped row numbers usually mean the rows are hidden by a filter, not erased. Clear the filter for the relevant column or choose Data > Clear. If rows remain hidden after clearing filters, check for manually hidden rows or grouping controls.

Filters affect the wrong data: Clear the filters, inspect the range, and make sure every record has the correct header and row alignment. If unrelated data is beside the list, select the intended range and enable filtering again, or convert the clean list to a table. Avoid sorting or filtering only one column of a multi-column dataset, because that can separate values from their records.

Frequently Asked Questions

Can I filter by more than one cell color in the same column?
Excel’s standard AutoFilter color menu is designed to filter by one selected cell color at a time in a column. To see multiple categories together, add a category or status field with text labels and filter that field, or run the color filters separately.

Can Excel filter cells colored by conditional formatting?
In supported desktop versions, the filter menu can offer colors that are currently displayed through conditional formatting. Results depend on the rule’s current outcomes and the colors present in the column. If the rule changes, the displayed colors and matching rows may change as well.

Does filtering by color change or delete my data?
No. It hides rows that do not match the selected color. Clear the filter to display them again. Be careful not to confuse filtering with deleting rows or sorting, which has a different effect.

Can I filter by font color or icon instead of cell fill?
Often, yes. Open the column filter menu and look for Filter by Font Color or Filter by Cell Icon when those formats are present. Select the option that matches the formatting you want to use; font color, cell fill, and icons are distinct.

Why does the color filter show no results?
The selected shade may not match any cells in the filtered range, the color may be in a different column, or another column’s active filter may be excluding those rows. Clear all filters, confirm the range and exact shade, and apply the color filter by itself as a test.

Can I filter by color in Excel for the web or on Mac?
Excel for Mac offers the same general ribbon-and-filter-menu process, though menus can look different. Excel for the web may also offer color filtering, but options can vary by version and workbook. Use Excel for Microsoft 365 on Windows if a required color option is unavailable in your current interface.

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.