Filter Excel by Highlighted Cells

Yes. In Excel for Microsoft 365 on Windows, open the filter arrow in the column containing the highlighted cells, choose Filter by Color, then select the fill color you want to keep. Excel displays only the rows whose cells in that column have that color; it does not filter by the temporary selection highlight made when you click or drag across cells.

What “highlighted” means in Excel

People use “highlighted” to mean two different things in a worksheet. A cell might have a lasting fill color—such as yellow applied with the Fill Color button—or it might simply appear selected because it is active or part of a selected range. Only actual formatting, such as a cell fill or font color, can be used with Excel’s color filter. A selection highlight is a temporary interface effect, not a cell value or formatting property, so Excel cannot use it as a filter condition.

There is a related distinction between a cell’s color and the reason it is colored. Someone may manually fill overdue tasks red, or conditional formatting may turn a task red when its due date passes. In either case, the visible color can be useful for filtering, but the color alone may not explain why the row qualifies. If the reason matters to other users, include an explicit status or category in the data as well.

Filter rows by fill color in Excel for Windows

For color filtering to work predictably, use a single header row and keep each record on one row. The filter is applied to a column, and Excel hides whole rows according to the color of cells in that column. For example, if a task list has a Priority column and high-priority cells are highlighted yellow, filter the Priority column—not an unrelated Notes column.

Click a cell inside the data range. Make sure the range has clear column headers, such as Task, Owner, Due Date, and Priority.
Turn on filtering if the dropdown arrows are not already visible. On the ribbon, choose Data > Filter. If the data is already an Excel table, its header row normally has filter arrows.
Open the dropdown arrow in the column where the color appears.
Point to or select Filter by Color, then choose the fill color to display. The menu may also offer font colors or conditional-formatting colors when those are present.
Review the remaining rows. Excel has hidden rows that do not match; it has not deleted them or changed their cell contents.

Suppose a sales table has red-filled cells in the Review Status column for orders that need attention. Filtering that column by red shows the matching orders, including the order numbers and customer details elsewhere on each row. If the same red fill appears in several columns for different reasons, filtering the wrong column can show a different set of records than you intend.

Filter by font color and conditional formatting

The Filter by Color menu can also filter by font color when text itself has been formatted, and it can offer icon filters when the column uses icon sets. Choose the kind of formatting that represents the category you want. A red font is not the same filter choice as a red cell fill, even though both look red on screen.

Conditional formatting is a common source of color. For instance, a rule might fill a Balance cell red when its value is below zero. Open the filter arrow for that column and check the color choices under Filter by Color. In supported desktop versions, Excel can filter by the color displayed by conditional formatting. This is often more useful than manually coloring cells because the appearance updates when the underlying values change. Still, verify the results after changing rules or data, especially if multiple rules can apply to the same cell.

Conditional formatting can also use icons, data bars, and color scales. These are not interchangeable with a simple fill. If the column displays icons and the filter menu provides an icon option, select the relevant icon. For a color scale, consider whether the menu’s available color choices match the specific group you intend to isolate; a helper category column may be clearer when the rule represents a business decision rather than one exact shade.

What the color filter does—and does not do

A color filter is a way to show or hide rows based on formatting in one column. If a matching cell belongs to a row containing ten other fields, the whole row remains visible. Excel does not isolate only the colored cells, nor does it move the matching rows together. If you want matching records grouped at the top while keeping all records visible, use a color sort instead: open the column dropdown, choose Sort by Color, and select the color. Sorting changes row order; filtering hides nonmatching rows.

Color filtering also does not infer meaning. If yellow means “waiting for approval” in one part of a workbook but “check this figure” elsewhere, Excel treats yellow as a formatting choice, not as a standardized status. The filter can return every yellow cell in the selected column whether or not the colors were applied consistently. For shared workbooks, consistent formatting rules and a written legend prevent ambiguity.

Finally, filtering by color is not the same as filtering by a value that happens to be colored. If the value is “Overdue,” filtering the text value is usually more dependable than filtering a red fill—provided the status is stored in the cells. A formula or ordinary worksheet filter does not generally read a cell’s fill as if it were data. Use the color menu for visual formatting, and use explicit values for logic that needs to be analyzed or reused.

Prepare the data for reliable filtering

Excel’s filters work best with a rectangular list: one header row, one record per row, and one type of information per column. A blank row or column splitting the list can cause Excel to detect only part of the data. Merged cells in the header area can also make filtering awkward. If the dataset is likely to grow, converting it to a table is a useful option: select a cell in the data and choose Insert > Table, confirm the range, and indicate that the table has headers.

Before filtering, check these details:

Put the highlight in the same column for every record you want to classify.
Use a consistent fill or font color. Similar shades may be treated as different choices.
Keep the header row distinct from the data, and avoid adding a second header partway down the list.
Check whether the color comes from a table style, manual formatting, or a conditional-formatting rule; these can look similar but are controlled differently.
If some rows are already hidden or another filter is active, clear or review those filters before deciding that color filtering missed records.

Tables are especially helpful for lists that expand because their filter controls and ranges adjust as records are added. They do not make color a dependable substitute for a status field, however. If users need to count, summarize, or exchange categories with another system, store the category as text or another explicit value.

Common problems and how to fix them

Filter by Color is missing. Confirm that you opened the arrow for a column containing formatted cells, rather than a different column or the worksheet’s general menu. Check that filtering is enabled with Data > Filter, and that the range includes the colored cells. If a table’s banded rows create the appearance of alternating colors, those visual bands may be table styling rather than individual cell fills; apply a real fill to the cells if you specifically need to filter by it.

The expected rows do not appear. Confirm you selected the exact color and the correct formatting type—cell fill versus font color. A light yellow and a slightly different yellow may be separate choices. Also inspect conditional-formatting rules: the visible color may be caused by a rule, while a manual fill you expected to see may be overridden or no longer displayed. Clear other active filters if you are unsure whether they are narrowing the results further.

Some records seem to be missing from the filtered range. Check whether the data is split by blank rows or columns, or whether the filter range ends before the last records. Reapply the filter to the complete list or convert the list to a table. Also check for hidden rows and confirm that the colored cell is in the filtered column for every record.

Filtering by color changes after an edit. That may be expected when conditional formatting controls the color. If a value changes and no longer meets the rule, its displayed color may change too, so it will no longer match the same color filter. If the classification must remain fixed, record it in a status column instead of relying on appearance alone.

Excel for Mac and Excel for the web

In current Excel for Mac versions, the general approach is similar: use the dropdown in the relevant column and look for Filter by Color. Ribbon placement and menu appearance can differ from Windows, so use the column’s filter menu rather than expecting every dialog to look identical. If the workbook is open in Excel for the web, check the column filter menu for color options; availability and presentation can vary by feature rollout and workbook context. Opening the file in the desktop app is a practical fallback if the option is not shown.

Regardless of platform, filtering by color is a display operation, not a conversion of formatting into data. If collaborators use different versions or need a repeatable report, a status column is easier to understand and maintain. A workbook can still use color to make those statuses visible while filtering by the underlying text value.

When a helper column is a better alternative

Use a helper column when the highlight stands for a meaningful condition, when users need to count the category, or when the results must remain consistent even if someone changes formatting. For example, add a Review Status column with values such as Needs review and Complete, then filter by the text. Conditional formatting can color Needs review cells red, making the list easy to scan while leaving the category available to formulas, PivotTables, and exports.

This is also the right approach when color is applied inconsistently or when the same color has multiple meanings. Excel worksheet formulas do not provide a general built-in way to test a cell’s fill color as ordinary data. Avoid building a process around the assumption that changing a cell’s color automatically changes a formula result. Store the condition explicitly, and use formatting as a visual cue for that condition.

Frequently Asked Questions

Can I filter Excel by the color of a cell?
Yes. Open the filter arrow for the column containing the colored cells, choose Filter by Color, and select the fill or font color. Excel then shows rows matching that formatting in the selected column.

Can I filter by cells highlighted with Conditional Formatting?
In supported Excel versions, the color filter can use the color displayed by conditional formatting. Open the filter menu for the column and check its color choices. If the result is unclear, verify the conditional-formatting rule and consider filtering by the underlying value instead.

Can I filter by the cells I currently have selected?
No. The selection shading that appears when you click or drag across cells is temporary and is not cell formatting. Apply a fill color to the cells or create a status column, then filter based on that information.

Can I filter by color without a header row?
Filtering is designed for a list with headers. Add a clear header row and apply Data > Filter, or convert the range to a table with Insert > Table. This gives each column a filter menu and makes it easier to target the correct field.

How do I remove a color filter?
Open the dropdown in the filtered column and choose Clear Filter From followed by the column name, where that command is shown. You can also use Data > Clear to clear filters from the range. The rows reappear; their formatting is not removed.

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.