How to Filter Rows by Color in Excel: A Practical Guide

To filter rows by color in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the filter arrow on a column that contains the color, and choose Filter by Color. Select the cell color, font color, or formatting icon you want to keep. Excel then shows the matching records and hides the others; it does not delete any rows.

This is useful when color marks a status, priority, review result, or category and you want to see those records together. Before you start, make sure the color is present in a column you can filter, and that your data has a clear header row. The steps below cover manually applied colors and colors produced by conditional formatting.

What You’ll Need

An Excel workbook with a range of related data, such as a task list or order table.
A header row with a distinct label for each column. Avoid blank header cells and merged cells in the data range.
A color applied to cells in at least one column. This can be a fill color, a font color, or an icon from conditional formatting.
Permission to edit the workbook if you need to add filters or change formatting. If the sheet is protected, filtering may be restricted by its protection settings.

Step-by-Step

Check how the color identifies a record. Find the column where the relevant cells are colored. For example, a task list might have Task, Owner, Due Date, and Status columns, with the cells in Status filled green for complete tasks. Filtering the Status column by green will show the matching task rows across the whole list. If the color appears only in a different column, you will need to use that column’s filter arrow instead.
Confirm that your data is arranged as a single list. Each column should have a heading, each row below it should represent one record, and there should not be a completely blank row or column dividing the list. A blank line can make Excel guess that only part of your data is the filtering range. If the list is long, click inside it and check that the selection covers the intended records before proceeding.
Turn on filter arrows. Click a cell inside the list. On the ribbon, select Data > Filter. Excel adds a drop-down arrow to each header. You can also select the data range first and use the same command. If Excel selects only part of the list, undo the command, select the complete range including headers, and turn on Filter again. In many workbooks, converting the range to a table with Insert > Table also adds filter arrows automatically; confirm that My table has headers is checked if the first row contains headings.
Open the filter menu for the color column. Select the arrow in the header of the column containing the colored cells. Do not open the arrow on a column that has no relevant color: its menu may not offer the color you need. If the list is in a table, the arrows are part of the table’s header row and work the same way.
Choose the type of color filter. In the menu, point to or select Filter by Color. Excel displays the available color choices, such as Cell Color, Font Color, or Cell Icon, when the corresponding formatting exists in that column. Choose the category that matches the formatting you are trying to filter. For a colored background, choose a cell color; for colored text, choose a font color.
Select the specific color or icon. Click the swatch or icon that represents the records you want to display. Excel filters the list so rows with that formatting in the chosen column remain visible. The other rows are hidden temporarily, not removed. Look for the filter indicator on the header arrow to confirm that a filter is active.
Check the visible records before using them. Read across the displayed rows to confirm that the filter is based on the intended column and color. If the visible list is still too broad, apply an additional filter on another column, such as a date or owner. Multiple filters combine, so a second condition further narrows the records rather than replacing the first one.
Clear or change the filter when finished. Open the same column’s arrow and choose Clear Filter From followed by the column name, or use Data > Clear to clear filters across the range. The exact wording in the menu can vary slightly by Excel build. To show all records while keeping filter arrows, clear the filter; to remove the arrows, select Data > Filter again.

Example: Suppose a project tracker has columns for Project, Owner, and Review Status. The Review Status cells are filled yellow when a review is pending and green when it is approved. Open the Review Status arrow, choose Filter by Color > Cell Color, then choose yellow. Excel displays the pending-review projects, including each project’s owner, because the filter hides or shows entire records based on the selected column.

Common Mistakes

Filtering the wrong column: Excel filters based on formatting in the column whose arrow you opened. If a row is shaded across several cells, use a column where the relevant color is actually applied. Row shading in other columns does not necessarily make a filter on this column match.
Confusing fill color with font color: A blue background and blue lettering are separate formatting properties. Choose Cell Color for the background, or Font Color for the text. A choice under one category will not match a color used only under the other.
Expecting a color to mean the same thing in every row: A manually colored cell and a conditional-formatting color may look alike but come from different rules. The filter works with the displayed formatting, but confirm that the formatting is applied consistently to the cells in the chosen column.
Selecting only part of the list: If the range has blank rows, blank columns, or separated sections, Excel may add filter arrows to just one section. Remove the filter, select the full list, and turn it on again, or make the data a properly structured table.
Assuming filtering deletes records: Filtered-out rows are hidden from view. They remain in the workbook and return when you clear the filter. Avoid copying or editing visible cells until you have checked which rows are currently shown.

Tips

Use a dedicated status column. A column with values such as Pending, Approved, and Complete is easier to filter and maintain than colors alone. You can still use colors to make those statuses easy to scan, while the text remains clear for readers and accessible to people who do not distinguish the colors.
Keep the headers simple. Use one nonblank heading per column and avoid merged cells in the list. Clear headers make it easier to identify the correct filter arrow and help Excel recognize the data range.
Use conditional formatting consistently. If a rule colors cells based on their values, check that the rule covers the entire relevant column or range. Otherwise, some records may not show the expected color and will not be included when you filter by it.
Check for more than one color meaning. If multiple shades represent different categories, select the exact swatch shown in the filter menu. Similar-looking shades are still different formatting values and can produce different results.
Remember that filters can be combined. You can filter one column by color and another by text, number, or date. To diagnose an unexpectedly empty list, clear the other filters first and then apply the color filter on its own.
Consider sorting by color instead. If you want all colored records grouped together but still want to see every row, use the column arrow’s Sort by Color option where available. Sorting rearranges the order; filtering hides rows that do not match.

Troubleshooting

There is no Filter by Color option. First open the arrow on the column that contains the formatting, not a neighboring column. Check that at least one cell in that column has a fill, font color, or supported icon. If the cells are plain, the color choices may not appear. Also make sure filter arrows are enabled with Data > Filter and that you are opening a header arrow rather than a cell’s right-click menu.

The color I want is not listed. The filter menu lists formatting found in the selected column, not every color used elsewhere in the worksheet. Verify that the cells have the intended color in this column. For conditional formatting, check the rule and its applied range; a rule may color cells only when a condition is currently true. If the color was recently changed, reopen the filter menu after the change.

Rows that look the same are missing. Their formatting may not be identical. One cell might have a manually applied fill while another gets its appearance from a conditional-formatting rule, or they might use different shades. Inspect a missing cell’s formatting and the relevant conditional-formatting rule. Apply one consistent formatting method if you want all those rows to match a single color filter.

The filter shows no rows. Clear other active filters using Data > Clear, then try the color filter by itself. Confirm that the selected column contains cells with that exact color and that the filter range includes those rows. Also check whether a conditional-formatting rule has changed the visible color because the cell values or formula results changed.

Only one column seems to be filtered. Excel’s filter condition is applied to a column, but matching records are displayed across the whole filtered list. If other columns are outside the range that received filter arrows, remove the filter and select the complete data range before turning it on again. Converting the list to a table can help keep its columns together.

The commands look different on Mac or in Excel for the web. The ribbon layout can vary by platform and window size. On Mac, use the filter arrow in the relevant header and look for the color-filter choices in its menu; ribbon labels or placement may differ. In Excel for the web, available filter options can depend on the workbook and current interface. If a color-filter choice is unavailable, open the workbook in the desktop Excel app and use the steps above.

Frequently Asked Questions

Can I filter by color when the color comes from conditional formatting?
Usually, yes. Open the filter arrow for the column whose cells display the conditional formatting, then look under Filter by Color for the displayed cell color or icon. The rule must currently produce that formatting in the cells you want to find.

Can I filter a whole row by its color?
The filter is selected from a column, and Excel shows or hides whole records based on that column’s cells. If you colored an entire row, choose a column in which the matching color is applied consistently. If no single column carries that formatting, consider adding a status field that records the category explicitly.

Can I filter by more than one color at once?
A standard color filter selects one color choice at a time for that column. To show multiple categories, you can use a status column and select multiple text values in its filter menu, or apply a separate method such as sorting by color to group the colors without hiding rows.

Will filtering by color change or delete my data?
No. It hides rows that do not match the selected color. Clear the filter to show them again. Sorting by color is different: it changes row order, but it also does not delete records.

Can I filter by a color that appears in another column?
Open the filter arrow on the column containing that color. Excel does not use the color in an unrelated column to decide whether a row matches a filter on the current column. If necessary, add a consistent status or category column and filter that instead.

How do I remove all filters but keep the arrows?
Select Data > Clear to clear the active filter criteria while leaving the filter controls available. To remove the arrows as well, select Data > Filter to turn filtering off.

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.