Google Sheets Filter by Color: Steps and Limitations

Yes. In Google Sheets in a web browser, create a filter, open the filter menu on the column you want, and choose Filter by color to show rows whose cells have a particular fill color or text color. The filter hides nonmatching rows; it does not delete them, and the color itself remains formatting rather than data.

What filtering by color does

A color filter is a way to narrow a table according to how cells look. For example, a project tracker might use a red fill for overdue tasks, yellow for items in progress, and green for completed work. Filtering the Status or Due Date column by a chosen color lets you view only the rows marked with that color while leaving the rest of the sheet intact.

The filter applies to a column in a filtered range, not to the entire sheet as an independent search for colored cells. Sheets checks the color of cells in that column and hides or displays the corresponding rows. A red cell in a different column does not make a row match a filter set on the current column.

Google Sheets offers filtering by fill color and by text color. Fill color means the cell background; text color means the font color. These choices are useful when color carries information, but they work best when the data is arranged as a consistent table with one record per row and a clear header row.

How to filter by fill or text color

Start by selecting a cell in the data range, or select the range you want to filter. Make sure the first row of the range contains column headings. Then use the following steps in the browser version of Sheets:

Choose Data > Create a filter. Filter icons appear in the header cells of the selected range.
Click the filter icon in the column that contains the colored cells you want to use.
Point to Filter by color.
Choose Fill color or Text color, then select the color to keep visible.

For instance, if the Task column uses a red background for overdue work, open the Task column’s filter menu and choose the red fill color. Sheets keeps rows whose cells in that column match the selected color and hides the other rows in the filtered range. To see every row again, reopen the filter menu and clear the color filter, or turn off the filter with Data > Remove filter.

If the sheet already has a filter, you do not need to create another one. Open the relevant column’s filter menu and change its settings. A filter icon in a header indicates that a filter is active for the range, though it may be filtering by values or a condition rather than by color.

Filtering by color in a filter view

A regular filter is useful when one shared view of the data is appropriate. In a collaborative spreadsheet, changing that filter can affect what other people see in the sheet. If different people need different temporary views, use a filter view instead. Filter views let users apply and save their own views without changing the shared filter state for everyone else.

To make one, choose Data > Filter views > Create new filter view. Sheets opens the range in a filter-view interface. Use the filter icon in the desired column and choose Filter by color, then select a fill or text color as you would with a regular filter. Give the view a descriptive name if you plan to return to it, such as “Overdue tasks” or “Green status rows.”

Filter views are especially handy for a shared work plan: one person can inspect overdue items while another checks completed work. They do not create separate copies of the data, and edits to the underlying cells still affect the shared spreadsheet. To leave a filter view, close it using the controls shown in Sheets; to reopen a saved one, use the Filter views menu.

What happens to conditional formatting?

Color can be applied manually with the toolbar or supplied by a conditional formatting rule. Conditional formatting changes a cell’s appearance when its contents meet a rule—for example, turning a date red when it is earlier than today. When color filtering is available for the range, you can use the displayed fill or text color as the filter choice, including colors generated by conditional formatting.

That does not make the color a dependable substitute for the underlying rule. If a conditional-formatting rule changes, a cell may acquire a different appearance and the rows matching a color filter can change too. A filter based on color is therefore a visual shortcut, not a stored category or a direct test of why the format was applied.

If the goal is “show dates before today,” a condition based on the date is usually clearer than filtering for red. The condition continues to express the intended test even if someone changes the formatting palette. Color filtering is most useful when the visual color itself is the practical selection criterion, or when reviewing a manually color-coded range.

Why a color filter may not work as expected

Several common issues can make the result look wrong. Check the following before changing the data:

Wrong column: The chosen color must be in the column whose filter menu you opened. A colored cell elsewhere on the row is not enough.
Range excludes some rows: If new records were added below or beside the filtered range, they may not be included. Remove and recreate the filter with the complete table selected.
Color is not actually the same: Two fills that look alike may be different shades. Select the exact color offered in the menu, and check whether the cells were formatted consistently.
Formatting is driven by a rule: A conditional-formatting rule may no longer apply to the cells you expect, or its conditions may produce a different color than anticipated.
Other filters are active: A value filter or condition in another column can further narrow the rows. Clear other column filters when diagnosing the result.
Headers or blank rows are inside the range: An inconsistent range can cause the filter icons to appear in the wrong place or leave records outside the filter.

Remember that hidden rows are still present. Clearing the filter restores their visibility; it does not undo edits, remove formatting, or change the contents. If rows seem to be missing after clearing a filter, check whether they were hidden manually or excluded by another filter.

Color filters versus value and condition filters

Google Sheets also lets you filter a column by its values or by a condition. Filtering by values is a good fit when you want a particular text or number, such as “In progress.” A condition is better for rules such as “Text contains,” “Greater than,” or a date condition. Those options inspect cell contents instead of cell appearance.

Use a color filter when the color is the information you need to inspect—for example, finding rows manually flagged with orange. Use a value or condition filter when the color merely represents data that already exists in the cell. A status column containing “Overdue” is easier to filter reliably by that word than by a red fill that someone might forget to apply.

Color filtering is not the same as sorting by color. Filtering hides rows that do not match the selected color; it does not rearrange the remaining rows into a color-based order. If you need a stable order, sort by a data column such as Status, Priority, or Due date, or add a category field and sort by that.

When a helper column is the better solution

Spreadsheet functions work with cell values, not ordinary formatting. There is no standard Google Sheets formula that directly asks whether another cell has a particular fill color. That limitation matters if you plan to build reports, charts, counts, or repeatable rules from color-coded data.

Instead, store the meaning behind the color in a dedicated field. For example, if cells in column A are colored to show a task state, add a Status column with entries such as “Overdue,” “In progress,” and “Complete.” Apply colors with conditional formatting based on the status values. Then you can filter by the status text, count categories, and change the color scheme without changing what the data means.

This approach also helps prevent ambiguity. Red might mean “late” in one table and “high priority” in another. A written label makes the category explicit, while color remains a visual cue. If a spreadsheet is imported, copied, or viewed by someone who cannot distinguish the colors, the underlying labels remain usable.

Good practices for reliable color filtering

A little preparation makes color filters easier to use and less likely to hide relevant records:

Keep one record per row, use a single header row, and avoid blank rows inside the table.
Use the same exact color for the same meaning throughout the relevant column.
Do not rely on color alone for critical categories; include a text label or other explicit value.
When collaborating, consider a named filter view rather than changing a shared filter.
After applying the filter, check the column and any other active filters before drawing conclusions from the visible rows.
Clear or remove the filter when finished so the next person does not mistake a partial view for the full list.

These practices are particularly important for inventory, attendance, task tracking, and review sheets, where a hidden row can be overlooked. A useful color convention should be documented near the table, and the same convention should be applied consistently rather than improvised cell by cell.

Frequently Asked Questions

Can Google Sheets filter by background color?
Yes. Create a filter, open the filter menu for the column containing the colored cells, and choose Filter by color > Fill color. Select the fill color you want to display.

Can I filter by font color in Google Sheets?
Yes. In the column’s filter menu, choose Filter by color > Text color, then choose the font color. The matching rows remain visible while other rows in the filtered range are hidden.

Can I filter by color without changing what collaborators see?
Use a filter view. Create one from Data > Filter views > Create new filter view, then apply the color filter inside that view. A regular filter may change the shared view of the sheet.

Can a Google Sheets formula detect a cell’s fill color?
Not with a standard built-in formula. Formulas evaluate values, not ordinary cell formatting. Store the category in a separate text or numeric field if you need to calculate or filter by the meaning behind a color.

Does filtering by color delete rows?
No. It hides rows that do not match the selected color. Clear the filter or remove it to show the rows again; the underlying data is still in the sheet.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.