To filter by text color in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the arrow in the column header, and select Filter by Color > Filter by Font Color. Choose the color you want to see; Excel hides the rows whose cells in that column use other font colors.
What a text-color filter does
In Excel’s menus, text color is usually called font color. A font-color filter shows rows based on the color of the characters in one selected column. For example, if a Status column uses red text for overdue items and green text for completed items, filtering that column by red font color shows the overdue rows.
The filter changes which rows are visible; it does not delete, recolor, or rearrange the underlying records. You can remove or change the filter later to see the rest of the data. This is different from sorting by font color, which reorders rows rather than hiding them. Both actions are available from the column’s filter menu in many Excel desktop versions.
Font color is also distinct from cell fill color. If the cells have colored backgrounds but the letters are all black, choose Filter by Cell Color, not Filter by Font Color. Excel may offer both options when the column contains those kinds of formatting, along with an option to filter by conditional-formatting icons when applicable.
Prepare the data before filtering
For reliable results, arrange the information as a simple list: one header row, one record per row, and a consistent field in each column. Make sure the column you want to filter has a clear header such as Status, Priority, or Review. A filter works on the rows in the selected data range or Excel table, so check that the range includes all the records you intend to examine.
It helps to use color consistently. If red means urgent in one part of the column but informational in another, filtering for red will collect both kinds of records. Color is a visual cue, not a label that explains why a record has that color. For a dataset shared with others, include a separate text field such as Priority or Reason as well as the colored formatting.
- Remove completely blank rows or columns from the middle of the list if they split the data into separate blocks.
- Confirm that the header row contains labels rather than data, and avoid merged header cells in the filtered range.
- Check a few cells in the target column to confirm that the characters themselves are colored, rather than only the cell background.
- If the data is an Excel table, use its header arrows; tables normally include filter buttons in their headers.
Filter by font color step by step
- Click a cell inside the list or table. If the range does not already have filter arrows, go to Data > Filter. On Windows, Ctrl+Shift+L toggles AutoFilter for the selected range.
- Open the drop-down arrow in the header of the column whose text color you want to filter. The color must be in that column; opening a different column’s menu filters according to that other column’s formatting.
- Point to or select Filter by Color in the menu, then choose Filter by Font Color. Excel displays the font colors it can filter in that column.
- Choose the color. The visible rows will be those whose cells in the chosen column have that font color. The arrow may show a filter indicator, and row numbers may skip because other rows are hidden.
For example, suppose a list has Task, Owner, and Status columns, and the words Late, On track, and Done are colored red, blue, and green. Open the arrow on Status and choose the red font color to display the Late records. The Owner column’s font color does not determine which rows appear unless you open and filter that column instead.
On Excel for Mac, the equivalent route is Data > Filter, then the target column’s header arrow and Filter by Color > Filter by Font Color. The ribbon layout and wording can vary slightly by release, but the key distinction remains font color versus cell color. In Excel for the web, available menu options can depend on the current interface; if a color-filter choice is missing, open the workbook in the Microsoft 365 desktop app and check the column there.
How conditional formatting affects the result
Font colors can be applied directly with the Font Color control on the Home tab, or they can be produced by a conditional-formatting rule. In current desktop Excel, Filter by Color can be used with colors produced by formatting rules as well as colors applied manually. The filter is based on the displayed formatting in the selected column, so a rule that turns overdue dates red can help you show those rows.
Conditional formatting is dynamic: its appearance can change when a value changes, a formula recalculates, or a rule’s range is adjusted. If the filtered results seem out of date, check the rule’s Applies to range and conditions, then confirm that the cells currently display the expected font color. Also check for overlapping rules, because rule order and settings can affect which format is displayed. Filtering by the visible color does not explain which rule caused that color; inspect Home > Conditional Formatting > Manage Rules to review the rules.
A useful safeguard is to store the underlying condition in a normal data field as well. For example, a Status value of Late can drive red conditional formatting. Filtering by the text value Late is often easier to audit than filtering by red alone, while the color remains a quick visual signal. This also avoids relying on color as the only way to communicate important information.
Filtering one color, several colors, or blanks
A color filter generally selects one font color at a time from the available choices in the column’s menu. If you need to include two colors—for example, red and orange priorities—apply a filter that represents the actual categories, such as a text filter on a Priority field, or use a helper category column. A single color selection is not the same as selecting several text values in the checkbox list.
Likewise, blank-looking text is not necessarily the same as a blank cell. A cell may contain text formatted in white, making it appear empty on a white background, or a conditional-formatting rule may make its text difficult to see. A font-color filter can reveal cells that share a formatting color, but it does not classify what their contents mean. If you are investigating missing values, use the column’s blank-value options or inspect the cell contents rather than assuming that white text means the cell is empty.
Common problems and how to fix them
- Filter by Color is missing. Check that you opened the arrow for the correct column and that the selected range includes the formatted cells. If the column does not contain a detectable font color, Excel may not offer a useful color choice. Try the desktop app if you are working in a browser with a different interface.
- The wrong rows remain visible. Confirm that you chose Filter by Font Color rather than Filter by Cell Color, and that the color appears in the filtered column. A colored word in the Owner column will not be found by filtering the Status column.
- Some similar-looking colors do not group together. Two colors can look nearly identical while being separate formatting choices, such as a theme color and a custom color. Inspect the font-color settings or standardize the formatting before filtering if precise grouping matters.
- Rows appear to be missing. Another column may also have an active filter. Open its arrow and check the selected values, or use Data > Clear to clear active filters and start again. Hidden rows can also result from manually hiding rows, which is separate from filtering.
- The data below the list is not included. Check whether a blank row or column separates it from the filtered range. Clear the filter, select the complete list, and apply Data > Filter again, or convert the continuous range to a table with Insert > Table.
- Color changes but the results do not match expectations. Reapply or clear the color filter after checking conditional-formatting rules and the cells’ current appearance. If the color is controlled by a rule, verify that the rule applies to the intended records.
Clear the filter or use another approach
To show all rows again while retaining the other filter settings, open the same column’s header arrow and choose Clear Filter From the column name, when that command is available. To remove all active filters from the range, use Data > Clear. You can also open the menu and select the relevant font-color option again or choose the menu’s clear-filter command. Clearing a filter does not remove the font formatting.
Use a text-value filter when the records already contain meaningful labels, such as Late or Approved. Use a color filter when the color itself is the category you need to inspect, or when the underlying text values vary but share a meaningful visual format. If color is calculated from a rule, filtering by the text or date condition that drives the rule is often more dependable for repeatable reports.
For a lasting workflow, consider adding an explicit category column and using conditional formatting only to display that category visually. Excel worksheet formulas do not provide a general built-in function that reads a cell’s font color, so a formula-based helper column cannot normally identify arbitrary manually applied font colors. A category field avoids that limitation and makes filtering clearer to colleagues, accessible to readers who cannot distinguish colors, and easier to summarize.
Frequently Asked Questions
Can I filter by font color in Excel?
Yes. Turn on filters with Data > Filter, open the relevant column’s header arrow, and choose Filter by Color > Filter by Font Color. Select one of the available colors to show matching rows.
How do I filter by cell background color instead?
Use the same column menu, but choose Filter by Cell Color rather than Filter by Font Color. The first option looks at the cell’s fill; the second looks at the color of its characters.
Can I filter by a color made by conditional formatting?
In desktop Excel, color filtering can use the displayed colors from conditional formatting. Check that the rule applies to the intended cells and that the color is currently visible. Filtering by the value that triggers the rule can be easier to maintain.
Can I filter for more than one font color at once?
The color menu generally lets you choose one color at a time. To combine categories, filter a text field that identifies them, or add a category column that groups the colors you need.
Does filtering by color delete or change my data?
No. It hides rows that do not match the selected color; it does not delete records or change their formatting. Clear the filter to display the full list again.
Related
- Free Excel Meal Plan Template: Build a Weekly Planner
- Fixing Broken Links in Excel: Find and Repair Them
- Find Same Names in Two Excel Columns
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Compare Hours in Excel With Formulas and FormattingTo compare two times in Excel, enter them as real time values and use a comparison formula such…
- How to Filter by Number in Excel: A Step-by-Step GuideTo filter by number in Excel, select a cell in your data, choose Data > Filter, open the…
- Trim Excel Column Values and Remove Extra SpacesTo trim values in an Excel column, enter =TRIM(A2) in a blank column beside the first value, fill…
- How to Filter by Year in Excel: A Clear, Practical GuideTo filter a date column to one calendar year in Excel, select your data, choose Data > Filter,…
- Copy and Paste Dates in Sequence in Excel: Step-by-StepTo create dates that increase in order, enter the first two dates in adjacent cells, select both, and…
- Add a Border in Excel Using a Formula: Step-by-StepTo add a border based on a formula in Excel, use conditional formatting: select the cells, choose Home…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.