Filter by Text Color in Excel: Steps, Limits, and Tips

Formulas & functions · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, you can filter a column by font color: open its filter arrow, choose Filter by Color, and select the font color you want to keep visible. Excel hides rows that do not match; it does not change or delete their contents.

What filtering by text color means

Excel calls the color of characters font color. Filtering by font color shows the rows in a column whose cells display a chosen font color, such as red or blue. It is a formatting-based filter, not a search for particular words. For example, filtering a Status column by red font can show every row whose Status cell has red lettering, whether the text says “Overdue,” “Review,” or something else.

The distinction matters because people often use “text color” to mean either the character color or the background behind a cell. Excel treats those as separate formatting properties. A font-color filter targets the letters; a cell-color filter targets the fill behind them. If the color you care about is the background, choose the fill color instead.

Color filters are most useful when color already conveys information, such as manually marking items for review. They can also help inspect a formatted report without rearranging the data. However, color alone is not a reliable substitute for a meaningful category: a reader may not know what red signifies, and colors can be difficult for some people to distinguish. Where possible, pair color with a clear label such as “Needs review.”

How to filter by font color in Excel for Windows

Set up the data as a continuous range with a header row. A filter applies to records in the range, so each row should represent one item and each column should have a distinct heading. Then use these steps:

  1. Click a cell in the data range. If Excel does not identify the whole range correctly, select the range yourself, including its headers.
  2. On the ribbon, choose Data > Filter. You can also use Home > Sort & Filter > Filter.
  3. Open the filter arrow in the header of the column whose font color you want to filter.
  4. Point to or select Filter by Color, then choose the font-color swatch you want. If the menu offers both font and cell colors, select the font color rather than the fill color.

The visible records should now be those with that font color in the chosen column. A filter indicator in the header shows that the column is filtered. To show all rows again, open the same arrow and choose Clear Filter From followed by the column name, or use Data > Clear to clear filters across the range.

For a quick toggle of filter arrows on Windows, press Ctrl+Shift+L. This shortcut turns AutoFilter on or off; it does not itself choose a color. On a Mac, use the ribbon’s Data > Filter command if the Windows shortcut does not apply in your Excel version or keyboard setup.

Filter by font color or by cell fill?

Before selecting a color, identify which part of the cell is colored. Consider a table in which overdue dates have red lettering, while high-priority rows have a yellow background. Filtering by red font finds the overdue-style entries; filtering by yellow cell color finds the priority entries. Those filters can return different rows even though both use color.

Excel’s filter menu may list the colors available in the selected column. Choose the color swatch that matches the formatting you want to use as the criterion. A color may not appear as an option if no cell in that column currently uses it. Also, a cell that looks colored because of a border, an icon, or a shape is not necessarily using font color or cell fill, so it may not be available through these options.

Filtering and sorting by color are related but different. A filter temporarily hides nonmatching rows. Sorting by color changes the order of rows so cells with a selected color move together, while keeping the records in the worksheet. Use a filter when you want to focus on one group; use a sort when you want to see that group alongside the rest of the data.

What happens when you apply a color filter?

A color filter works on the selected column and hides whole rows whose cells in that column do not meet the color criterion. The data is still in the worksheet. Clearing the filter restores the hidden records, and filtering does not rewrite the text or remove its formatting.

Filters on different columns can be combined. For instance, you could filter a Review column to show red font and then filter a Region column to show “West.” Excel displays rows that meet both active conditions. This is useful for narrowing a large list, but it can also make a result look incomplete if another column has an unnoticed filter. Check the header arrows when expected rows seem to be missing.

Color filtering is based on formatting as it appears in the cells, rather than on the meaning of the text. If someone changes a cell’s font color, the row may no longer belong in the filtered group. That makes color filters convenient for visual review but less suitable as the only method for tracking a process that must remain consistent over time.

Conditional formatting and changing colors

Font color may be applied manually from Home > Font Color, or it may appear as the result of a conditional-formatting rule. Excel can filter by the displayed font color in supported desktop versions, including colors produced by conditional formatting. The rule’s condition and the filter’s color choice are still separate things: the rule determines which cells look a certain way, while the filter selects rows based on that appearance.

For example, a rule might turn negative balances red. A font-color filter can then show the rows currently displayed in red. If a balance changes and the conditional formatting changes its appearance, the row’s color category can change too. When the visible results do not seem current after editing data or rules, clear and reapply the color filter, then confirm that the expected cells still display the chosen color.

If the color represents a durable business category, store the category in a separate column as text—such as “Overdue,” “On track,” or “Needs review”—and filter by that value. The formatting can remain as a visual cue, while the text field provides a clearer and more dependable filter criterion.

Common problems and their fixes

  • There is no font-color choice. Confirm that the selected column contains cells with font colors, and open the filter arrow for that same column. Check that the range has filter arrows and that you are not looking only at the fill-color options.
  • The wrong rows appear. Make sure you chose font color rather than cell fill, and verify that the cells in the filtered column—not a different column in the row—have the color you intend to match.
  • Some records seem missing. Look for other active filters in the table. Clear them one at a time or use Data > Clear to remove the current filters.
  • New rows are not included. Check whether the new data is inside the filtered range. Converting a well-structured range to an Excel table with Insert > Table can make it easier for the table to include added records and carry filter controls through the data.
  • The color is hard to match. Similar shades may be difficult to distinguish in a large palette. Check the actual cell formatting and, for important categories, add a text label rather than relying on a shade alone.

One common misconception is that a filter by color searches for a word that is associated with that color. It does not. If you want every cell containing the word “urgent,” use the text filter options in the column menu. If you want every cell whose letters are red, use the font-color filter. The two criteria can be combined only when the data and filter setup support the separate conditions you need.

Alternatives when color is not enough

If you need to filter several colors at once, apply a meaningful category in a helper column and filter that column. For example, replace the informal convention of “red means late, orange means due soon” with a Status column containing “Late” and “Due soon.” This makes the logic visible, allows ordinary text filtering, and helps avoid confusion if someone changes a font color by mistake.

Excel worksheet formulas do not provide a standard function that returns a cell’s font color as a normal value. A formula that checks the text in a cell can identify a word or number, but it cannot directly use the cell’s font formatting as its criterion. If a workflow truly must classify cells by formatting automatically, it may require VBA or another automation approach. That adds maintenance and security considerations, so a data column is usually the simpler option.

You can also use Data > Sort to sort by font color when the goal is to group colored rows without hiding the rest. If the color is generated by conditional formatting, consider whether its underlying rule can be expressed as a category in the data. Filtering on the category is easier to explain and repeat than filtering on a visual result.

Excel for Mac and the web

Excel for Mac also provides AutoFilter and color-based filtering in supported versions. The ribbon layout and menu presentation can differ from Windows, but the general approach is to turn on filtering, open the relevant column’s filter arrow, and choose the desired color option. If the command is not visible, check that the range has headers and that the column actually contains the font color you want to filter.

Excel for the web has a different, more compact interface, and available commands can vary with the current version and rollout. Open the column’s filter menu and look for Filter by Color. If the font-color choice is unavailable in your browser session, open the workbook in the desktop app, or use a text category column as a dependable alternative. The Windows ribbon paths above refer to Excel for Microsoft 365 desktop.

Frequently Asked Questions

Can I filter by font color in Excel?
Yes. Turn on filters, open the relevant column’s header arrow, and select Filter by Color followed by the font color you want to display.

Can Excel filter by font color and cell color?
Yes, where those color-filter options are available. Font color applies to the characters; cell color applies to the background fill. Choose the correct type in the column’s filter menu.

Does filtering by color delete the other rows?
No. It hides rows that do not match the selected color. Clear the filter to display them again; filtering does not delete the records.

Can I filter by more than one font color in the same column?
The color filter is designed to select a color at a time for a column. If you need a group containing several colors, use a helper column with a shared category or filter the underlying values instead.

Can I use a formula to filter by font color?
Not with a standard worksheet formula that directly reads font formatting. Add a text category to the data for a straightforward formula-friendly approach, or consider automation only if the process genuinely requires it.

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.