Excel Color Filter: How to Filter Rows by Cell Color

To filter rows by color in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the dropdown in the column you want to filter, and select Filter by Color. Pick a fill color, font color, or conditional-formatting color to show matching rows. Filtering hides rows that do not match; it does not delete them or change their formatting.

What You’ll Need

An Excel worksheet containing a list or table with a header row. The column you want to filter should contain cells with the color you plan to select.
Permission to edit the workbook if it is protected or shared with restrictions. If the color came from conditional formatting, leave that rule in place while filtering.

You do not need to convert the data to an Excel table, although a table can make filtering easier to manage. If your data has no header row, add one before turning on filters so Excel can label each column’s dropdown.

Step-by-Step

Check the data layout. Make sure each column has a distinct header, such as Status, Priority, or Owner, and that the records form one continuous range. Avoid completely blank rows or columns inside the list; they can make Excel detect only part of the data. If the range is already an Excel table, its header row should have filter arrows automatically.
Select a cell in the list. Click any cell inside the data range. You normally do not have to highlight every row and column first: Excel detects the surrounding contiguous data. If the worksheet contains separate blocks of data beside each other, select the specific range you want before enabling filtering so the wrong block is not included.
Turn on the filter arrows. On the ribbon, choose Data > Filter. You can also use Home > Sort & Filter > Filter. On Windows, Ctrl+Shift+L toggles AutoFilter on or off. Confirm that a dropdown arrow appears beside each header. If the data is a table, use its existing header arrows rather than creating a separate filter range.
Open the dropdown for the colored column. Click the arrow beside the header for the column that contains the color you care about. For example, if red fill marks urgent tasks, use the dropdown in the Priority column, not an unrelated column. Filtering by color is applied through the dropdown for the column whose cells have that color.
Choose the color-filter option. In the dropdown menu, point to or select Filter by Color. Excel may show choices for Cell Color, Font Color, or both, depending on the colors and formatting in that column. If the cells use conditional formatting, the displayed formatting may appear as a selectable color option as well. Choose the relevant category, then click the color swatch you want to keep visible.
Check the filtered results. Excel hides rows whose cells in that column do not match the chosen color. The filter arrow usually shows a filter indicator, and the row numbers may skip because some rows are hidden. Check a few visible records against the original list to confirm you filtered the intended column and selected the right shade.
Apply another condition if needed. You can filter a second column while the first filter is active. For example, filter the Status column by a green fill and then filter the Region column by a region name. Excel shows rows that meet both active filters; it does not treat separate column filters as alternatives. To replace the color selection in the same column, reopen its dropdown and choose a different color.
Clear the filter when finished. Open the filtered column’s dropdown and choose Clear Filter From [column name], or use Data > Clear to clear filters from the range. Clearing a filter makes the hidden rows visible again but leaves cell fills, font colors, and conditional-formatting rules unchanged. To remove the arrows entirely, choose Data > Filter again; this turns AutoFilter off rather than deleting the data.

Example: Imagine a task list with a Status header in column B and red-filled cells for overdue tasks. Open the filter arrow beside Status, choose Filter by Color, then select the red cell color. Excel displays the rows whose Status cells have that red fill. If a row is overdue but its status cell is not red, it will not be included just because another cell in the row is red.

Common Mistakes

Opening the wrong column’s menu. The color filter applies to the cells in the column whose arrow you opened. A red fill elsewhere in the same row does not qualify the row when filtering a different column.
Expecting the filter to create color. Filter by Color only selects existing formatting. To add a fill manually, select the cells and choose a fill from Home > Fill Color. To color cells based on values, create a rule from Home > Conditional Formatting.
Confusing a filter with a sort. Filter by Color hides nonmatching rows. Sorting by color rearranges rows into groups but keeps them visible. Choose the command that matches whether you want to narrow the displayed records or reorganize them.
Selecting a similar but different shade. Light red and dark red are different colors to Excel. If results are missing, check whether the cells use more than one shade, or whether the color is a font color instead of a fill color.
Filtering only part of the list. Blank rows, blank columns, or manually selected ranges can cause Excel to omit records. Clear the filter, check the data boundaries, and enable the filter again with a cell inside the complete list selected.
Assuming hidden rows were deleted. A filter temporarily hides rows. Do not copy or edit visible results without checking what is selected, especially if the goal is to work with the full dataset later.

Tips

Use a table for a list that grows. Select the data and choose Insert > Table, making sure My table has headers is checked. Tables include filter arrows and generally extend their filtering behavior as you add rows. They are especially useful for recurring reports.
Give color a clear meaning. A color key or legend can explain what red, amber, and green represent. This helps other people interpret the filtered results and reduces the chance that a decorative fill is mistaken for a status.
Distinguish fill from text color. Cell Color refers to the background fill; Font Color refers to the color of the characters. If the dropdown offers both, choose the one that actually marks your records.
Use conditional formatting for changing categories. If a color depends on a value, a conditional-formatting rule can update the appearance as values change. Filter by the resulting displayed color when you need to see a particular category. If the underlying values are available, filtering directly by those values is often more reliable than using color as a label.
Keep an unfiltered view in mind. Before sharing or printing, clear filters if readers need to see all records. If you want to preserve a particular view without changing the source list, consider saving a separate copy or using a sheet view where available in your Excel version.
Remember that filters can combine. When you filter by color in one column and by a text value in another, Excel displays rows that satisfy both. Clear the earlier condition if the results seem unexpectedly narrow.

Troubleshooting

Filter by Color is missing. First confirm that you opened a column dropdown and that cells in that same column have a fill or font color. The menu may not offer a color category when there is no applicable color in that column. Check that the worksheet is not protected in a way that prevents filtering. If the option still does not appear, verify that you are working in the desktop Excel app; menus and available features can vary in Excel for the web and across versions.

The color is visible, but selecting it returns no rows. Check whether the color is a cell fill, a font color, or a conditional-formatting result, and select the matching category. Also inspect several cells for slightly different shades. If the displayed color comes from conditional formatting based on changing values, confirm that the rule still applies and that the values have recalculated. Reopen the filter menu and apply the color again after the display updates.

Some expected rows are missing. Confirm that the colored cell is in the column you filtered, and clear any other active filters that may be narrowing the results. Look for blank rows that split the data into separate ranges, then check whether the omitted records fall outside the filtered range. Turning filtering off and back on with a cell inside the full list selected can help Excel detect the correct range.

The arrows or filters seem to have disappeared. If the arrows are gone, choose Data > Filter to show them again. If the arrows remain but results look incomplete, open each filtered column menu and clear its filter, or choose Data > Clear. Remember that clearing a filter restores hidden rows; it does not remove formatting. If the worksheet is protected, filtering may be unavailable unless the sheet was configured to allow it.

Excel for Mac or the web looks different. The same general process applies: enable filtering from the Data tab, open the column’s dropdown, and look for a color-filter option. Ribbon placement and menu labels can differ by platform and update. If your version does not offer Filter by Color, open the workbook in Excel for Microsoft 365 on Windows or filter using the underlying value instead.

Frequently Asked Questions

Can I filter by more than one color in the same column?
Excel’s standard Filter by Color menu lets you choose one color at a time for a given column. To include multiple color groups, filter by another field that identifies those groups, or add a helper value to the data so the categories can be selected together.

Can I filter by font color instead of cell fill?
Yes, if the column contains font colors that Excel can identify. Open that column’s dropdown, choose Filter by Color, then choose Font Color and select the desired color. If the option is unavailable, check that the text color is applied in that column.

Does filtering by color work with conditional formatting?
It can work when the color is the displayed result of conditional formatting. Choose the matching color in Filter by Color. If rule results change later, refresh or reapply the filter so the visible rows reflect the updated formatting.

Will filtering by color change or delete my data?
No. It hides rows that do not match; it does not delete those rows or recolor cells. Clear the filter to show all records again. Be careful when copying visible results, since the filter changes which rows are displayed.

Can I filter by color and by a value at the same time?
Yes. You can apply a color filter to one column and a value filter to another. The displayed rows must satisfy both conditions. If the results are too limited, check all active column filters and clear any condition you no longer need.

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.