How to Filter Highlighted Rows in Excel by Cell Color

Formulas & functions · Updated November 20, 2026

To filter highlighted rows in Excel, turn on AutoFilter, open the dropdown for a column whose cells have the highlight color, and choose Filter by Color followed by the color you want. Excel will show rows where cells in that column display that color. Before you start, make sure your data has a header row and that the color you want to filter by appears in a consistent column.

What You’ll Need

  • A worksheet with a continuous data range or an Excel table, including a header row.
  • Highlighted cells in a column you can use to identify the rows. The highlighting can be a manually applied fill or a color shown by conditional formatting.
  • Microsoft Excel for Microsoft 365 on Windows for the steps below. In Excel for Mac or Excel for the web, the same basic filter-by-color option is available, although ribbon placement and keyboard shortcuts can differ.

Step-by-Step

  1. Check how the rows are highlighted. Find a column in which the relevant cells all carry the color you want to filter. For example, if you mark urgent orders by filling their Status cells red, use the Status column’s filter. Excel filters by the color of cells in the selected column; it does not automatically treat a color anywhere across a row as a row-level label. If the highlight is applied only to a different column, use that column instead.
  2. Make sure the data is set up as a filterable list. Keep one header row at the top, with a distinct heading for each column, and avoid completely blank rows or columns inside the data. Each record should occupy one row. If the list is already an Excel table, its headers usually have dropdown arrows, so you can move to the next step. To make a table, click a cell in the data, choose Insert > Table, confirm the range, and ensure My table has headers is selected when appropriate.
  3. Turn on filter dropdowns if they are not already visible. Click inside the data range, then select Data > Filter. Excel adds a dropdown arrow to each header. On Windows, Ctrl+Shift+L also toggles AutoFilter. In Excel for Mac, use Data > Filter if that shortcut does not work with your keyboard or Excel settings; in Excel for the web, use the Data tab’s Filter command. Avoid selecting only a small part of the list before turning filtering on, or some rows may be left outside the filter range.
  4. Open the dropdown for the color-identifying column. Select the arrow in the header of the column that contains the colored cells. For instance, use the arrow over Status if the status cells are highlighted, not the arrow over an unrelated column such as Customer. If the list is a table, the arrow is part of the table header. You do not need to select the colored cells themselves first.
  5. Open the color filter options. In the dropdown, point to or select Filter by Color. Excel displays the available cell fill colors found in that column, and may also show font colors or conditional-formatting icon options when those are present. Choose the fill color that matches the highlighted cells you want to keep visible. The menu’s color choices depend on the actual colors in that column, so a color that appears elsewhere in the worksheet may not be offered here.
  6. Check the filtered results. Excel hides rows that do not match the chosen color; it does not delete them. Look at the row numbers and the filter icon in the header to confirm that a filter is active. Check several displayed records to ensure the chosen color corresponds to the category you intended. Other column filters can remain active, so the visible results may also be narrowed by previous criteria.
  7. Clear the filter when you want the full list back. Open the same column’s dropdown and choose Clear Filter From [column name], or use Data > Clear to clear the worksheet’s filter criteria. This reveals hidden records without removing their formatting. To remove the dropdowns themselves, choose Data > Filter again. Clearing a filter and turning filtering off are different actions: the first restores rows while keeping the controls, and the second removes the controls.

Common Mistakes

Filtering the wrong column: A red fill in the Status column is not detected by opening the Customer column’s menu. Filter by the column where the relevant colored cell actually appears. If the same category is highlighted in different columns on different rows, one color filter may not capture every matching row.

Expecting Excel to filter a whole row based on any colored cell: The filter applies to the selected column’s cells, not to all cells across the row as a single unit. Applying a red filter in one column and then another generally narrows the results to rows meeting both column filters; it does not mean red in either column. If colors are scattered, add a consistent category or review flag in one dedicated column, then filter by that value.

Confusing similar shades or formatting with values: Two fills that look nearly identical can be separate colors, and a cell may appear colored because of a conditional-formatting rule rather than a manually chosen fill. Pick the exact color shown in the dropdown and verify the visible rows. A font color or an icon is not the same as a cell fill color.

Assuming hidden rows were deleted: Filtering temporarily hides nonmatching records. Sorting, deleting, or copying visible results can have different consequences. If you need a separate copy of the matches, first confirm the filtered results and copy them to another location carefully.

Tips

Use a dedicated flag column for repeatable filtering. If a row is important because of a highlight anywhere in its fields, consider adding a column such as Review status with values like Urgent or Check. Filter that column by text. This is easier to understand and maintain than relying on a color scattered across several fields, and it gives readers a label they can interpret without guessing the shade.

Keep the color scheme simple. Use one consistent fill for each meaning, and avoid using several near-identical shades for the same category. A legend near the data can explain what each color means, especially when a workbook is shared with colleagues.

Use a table for lists that grow. An Excel table keeps filter controls attached to the header and generally expands as you add records. Select a cell in the list and choose Insert > Table to create one. Check that the table range includes every intended data column and that the header option reflects whether your first row contains field names.

Combine color with other criteria deliberately. You can filter a color-identifying column and then filter another column by text, number, or date. Excel applies the criteria together, so a row must meet each active filter to remain visible. If results seem too limited, check every header for an active filter and clear criteria you no longer need.

Preserve the source data. A color filter is useful for reviewing a subset, but it does not replace a backup or a clear record of why a row was marked. If you plan to edit or delete records, clear the filter and confirm your selection before making changes.

Troubleshooting

Filter by Color is missing: Check that the dropdown belongs to the column containing the colored cells, and that the cells actually have a fill color or supported conditional-formatting color. The menu may not offer a fill choice if the selected column has no such fills. Confirm that AutoFilter is on and that you are looking at the header dropdown rather than a cell’s right-click menu.

The correct color is not listed: The dropdown lists colors present in that particular column, not every color in the workbook. Check that at least one cell in the filter range currently displays the intended color. If a rule is responsible for the appearance, review the conditional-formatting rule and confirm it applies to the range you are filtering. A color in another column will not appear in this column’s list.

Some expected rows are missing: Look for other active filters in the header row; several criteria work together. Also check whether the missing cells use a slightly different fill, are outside the filtered range, or display a color only under certain conditional-formatting conditions. Clear all criteria, confirm the range, and try again using the column where the target color is applied.

The filter includes unexpected rows: Compare the fill of those rows’ cells in the chosen column, not the color elsewhere in the row. Some fills may look the same but have been applied differently, while conditional formatting can change as cell values change. If the category needs to be exact and dependable, filter a text label in a dedicated column instead of relying on visual appearance.

Dropdown arrows or rows behave unexpectedly: Check for merged cells, blank header names, or blank rows splitting the list. These can make a range harder to filter consistently. Use a single, unmerged header row and a continuous data range, then select Data > Filter again. If the data is an Excel table, verify that the table includes the records you expect.

Frequently Asked Questions

Can I filter by a cell’s fill color in Excel?
Yes. Turn on AutoFilter, open the relevant column’s header dropdown, choose Filter by Color, and select the fill color. Only rows whose cells in that column match the selected color remain visible.

Can Excel filter a whole row if just one cell is highlighted?
Not automatically across all columns. The filter checks the color in the column whose dropdown you use. If the highlight could appear in different columns, put a consistent label or flag in one column and filter that column instead.

Does Filter by Color work with conditional formatting?
Excel can offer colors displayed by conditional formatting in the color-filter options. The result depends on the cells and rules in that column. If the option is unavailable or the results are unreliable, check the rule’s applied range and use a text category as a more robust filter.

Does filtering by color delete or change the hidden rows?
No. Filtering hides rows that do not match; it does not delete them or remove their formatting. Clear the filter to show the full list again. Take care if you later select, copy, or delete records while only some rows are visible.

Can I filter for two highlight colors at once?
Excel’s color filter menu selects one color at a time for a given column. To include multiple categories, consider filtering a text label in a helper column, or apply a process that identifies the categories you need before filtering. Remember that filters on separate columns are combined, not treated as an either-or choice.

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.