Excel Filter by Color and Value: How It Works

Yes. In Excel for Microsoft 365 on Windows, open a column’s filter menu and choose a color under Filter by Color; to combine that with a value condition, filter a different column as well. Excel combines filters across columns, but its standard AutoFilter does not reliably combine a color selection and a value condition in the same column.

What filtering by color does

A filter temporarily hides rows that do not meet your chosen criteria; it does not delete or rearrange the underlying records. Filtering by color lets you show rows whose cells have a particular fill color, font color, or conditional-formatting icon. Filtering by value instead selects items such as a specific text entry, a range of numbers, or dates within a period.

These options are useful when color conveys meaning in a worksheet—for example, yellow fill for items needing review or a red icon for overdue tasks. But color is a visual property, not automatically a data category. If the reason for a color matters to reporting, it is often better to record that reason in a separate field such as Status, Priority, or Review needed.

Prepare the data before applying filters

Filters work best when the data is a continuous, rectangular list with one header row. Avoid blank rows or blank columns inside the list, merged cells in the header, and multiple unrelated tables in the same range. Check that each column contains one kind of information: mixing dates with text, for example, can make value filters confusing.

For a structured list, click inside the data and choose Insert > Table, then confirm that the table has headers. Excel tables add filter buttons to their headers and usually expand automatically when rows are added. For an existing range, click inside it and choose Data > Filter. The header arrows indicate that filtering is available.

Filter rows by color

Click the filter arrow in the column whose cells contain the color you want to use.
Point to Filter by Color. Excel displays available cell fill colors, font colors, or icon choices when those formats are present in that column.
Choose the color or icon. Excel hides rows whose cells in that field do not match the selection.

For example, suppose a Status column contains green, yellow, and red fills. Choosing the yellow fill displays the rows with yellow cells in that column. The filter arrow usually changes to indicate that a filter is active. The row numbers may skip, which is normal: the other rows are hidden from view, not removed.

If the menu does not show the color you expect, confirm that the cells in the filtered column actually have that formatting. A color elsewhere in the row does not qualify. Also check whether the color is applied by a conditional-formatting rule, and whether the rule currently evaluates to that color for the rows you expect.

Filter by color and value together

Excel’s filters are additive across columns. Apply a color filter to one column, then open the filter arrow on another column and select a value condition. The visible rows must satisfy both filters. For instance, you could show yellow-filled Status cells and, at the same time, show only records whose Amount is greater than $500. The result is the intersection of those two groups, not either group on its own.

To set a value filter, open the relevant column menu. Depending on the data type, choose from text, number, or date options. A number column can use Number Filters, such as Greater Than; a date column offers date-related choices; and a text column can be narrowed to selected entries or text conditions. The exact menu choices depend on the values Excel recognizes in the column.

Here is a practical example: apply Filter by Color to the Review column and choose yellow, then use Number Filters > Greater Than on the Amount column and enter 500. Rows remain visible only when their Review cell is yellow and their Amount is above 500. A row with a green Review cell is excluded even if its Amount is $900; a yellow row with an Amount of $400 is excluded too.

Can you combine color and value in the same column?

This is the important limitation behind many searches for “filter by color and value.” The standard AutoFilter menu treats the filter for a field as one filter setting. If you choose a color and then try to add a value condition in that same column, Excel may replace the first filter rather than preserve both as an AND condition. Do not assume that a color choice and a text or number criterion in one field are working together; check the visible rows and the active filter menu.

If the color represents a real rule, the cleanest solution is usually to filter on the rule’s data instead. For example, if red means an amount is below 100, use a number filter for values below 100. If color marks a workflow state, add a Status field with values such as “Needs review” and filter that field directly. This approach is easier to audit, share, and use in summaries than relying on formatting alone.

If the color was applied manually and has no underlying data rule, Excel’s ordinary worksheet formulas cannot test a cell’s fill color. A helper formula can reproduce a rule only when that rule is based on the cell’s contents. Otherwise, consider adding a helper field and recording the category explicitly, or use a carefully reviewed automation approach suited to the workbook. Avoid treating a color as data when the workbook has no consistent convention for what that color means.

Conditional formatting, icons, and color meaning

Filter by Color can be useful with conditional formatting, such as a rule that colors low scores red or highlights duplicate values. When the formatting is based on a clear condition, filtering by the underlying value or condition is often more dependable than selecting the displayed color. Conditional formatting can change as data changes, so a color that identified one group yesterday might identify a different group after a cell is edited.

Icon sets are also visual indicators, but an icon is not the same thing as a cell’s fill color. If Excel offers Filter by Color choices for icons in that field, choose the relevant icon there. If you need a durable category for analysis, create a text or numeric field that records the category behind the icon. This makes the meaning clearer to people who use different themes, displays, or accessibility settings.

Filtering is different from sorting by color

Filtering by color hides rows that do not match. Sorting by color changes the order of rows so that a chosen color appears at the top or bottom, while keeping the other rows in the list. Use filtering when you want to focus on a subset; use sorting when you want to see all records grouped by their formatting.

Both actions are available from a column’s filter menu when Excel detects colors in that field. Sorting by color can be useful for reviewing every flagged record while retaining the rest of the list on screen. Neither action changes the cell’s color or the data value. If you later sort by another field, the color-based order may no longer be the visible grouping.

Clear filters and troubleshoot unexpected results

To remove a filter from one column, open that column’s menu and choose Clear Filter From followed by the column name. To clear filters from the whole range, use Data > Clear. This restores rows hidden by filters, but it does not undo formatting, delete data, or necessarily return a manually sorted list to its original order.

Some expected rows are missing: Check every column for an active filter. Filters across columns work together, so a second condition may be excluding the row.
The color is absent from the menu: Confirm that the color appears in the specific field being filtered, not merely elsewhere in the row. Inspect conditional-formatting rules as well.
Text or dates filter oddly: Look for mixed data types, extra spaces, blank cells, or values stored as text. Excel may offer different filter choices when a column contains inconsistent entries.
New rows are not included: If you used a plain range, verify that the filtered range includes the added rows. An Excel table generally expands when data is entered directly beneath it.
Filtered records seem gone: Clear the filters and check again. Filtering hides rows; it does not delete them.

Excel for Mac and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac also has column filter menus and filter options, though the ribbon layout and some menu presentation can differ. Look for the filter arrow in the header and the color or value choices in its menu rather than relying on a Windows-only screen description.

Excel for the web provides filtering for workbook data, but available controls can vary with the workbook and the web interface. If a color option is missing or a particular filter cannot be applied as expected, open the workbook in the desktop application and check the column there. Regardless of platform, keep a separate data field for important categories instead of making color the only record of a decision.

Frequently Asked Questions

Can Excel filter by color and value at the same time?
Yes, when the color and value conditions are in different columns: Excel combines the filters. In the same column, the standard filter menu does not reliably preserve both a color choice and a value condition together, so use an explicit helper field or filter the underlying data rule instead.

Does filtering by color delete rows?
No. It hides rows that do not match the selected color. Clear the filter to show them again. Filtering is different from deleting rows, although copying only the visible results elsewhere can create a separate subset.

Can I filter by a conditional-formatting color?
Excel can offer colors or icons used in a column’s conditional formatting in its filter menu. Because conditional formatting responds to data and rules, filtering the underlying condition is often more robust than filtering the resulting appearance.

Why can’t I see Filter by Color?
The filtered column may not contain cells with a recognized fill color, font color, or icon, or the formatting may be in a different column. Check the actual cells and their conditional-formatting rules, then reopen that column’s filter menu.

Will a color filter update when I change cell colors?
A filter is based on the formatting currently present, but after changing colors or conditional-formatting rules, review or reapply the filter if the visible results do not reflect the changes. For workflows where membership must stay clear, use a data field that states the category.

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.