Can You Sort Google Sheets by Color? Steps and Workarounds

Yes. In Google Sheets in a web browser, you can sort rows by a cell’s fill color or text color using a column’s filter menu: select your data, choose Data > Create a filter, then open the filter menu and choose Sort by color. This is useful for grouping color-coded records, but color is formatting rather than a value, so it works differently from sorting by text, dates, or numbers.

What sorting by color does

Sorting by color rearranges rows in a selected data range according to the formatting in one column. For example, if a project tracker uses red fill for overdue tasks, yellow for tasks due soon, and green for completed tasks, you can use the color in the Status or Due Date column to bring a particular color group together. The rest of each row moves with it, so names, dates, and notes stay associated with the correct record—as long as the filter covers the entire table.

Color sorting does not turn colors into categories or change the cell contents. A red-filled cell can still contain the word In progress, a date, or nothing at all. You can still sort by the underlying values through the usual filter options, but the color-based command uses formatting to decide which rows to group.

This distinction matters when you want repeatable, rule-based organization. A spreadsheet formula generally evaluates cell values, not a manually applied background color. If red means urgent, for instance, a text value such as Urgent is more useful for calculations and reporting than red fill alone.

Prepare the range before sorting

Before creating a filter, check that the data forms a consistent table. Put one header at the top of each column, avoid blank rows or columns inside the records, and make sure the range includes every field that belongs to each row. If you select only the color-coded column and sort it separately, the names or other details in adjacent columns may no longer match.

For example, a task table might have headers in row 1 and records in columns A through D: task name, owner, due date, and status. Select the whole table, including the headers, before creating a filter. If there are unrelated notes immediately beside the table, leave them outside the selection so they are not treated as part of the sortable data.

Keep a header row so the filter menu can identify the columns.
Include all related columns and records in the range.
Remove accidental blank rows within the table, or check that they do not split the data into separate blocks.
If the sheet contains important formulas or manually arranged sections, consider making a copy before a large reordering.

How to sort rows by color in Google Sheets

These steps are for Google Sheets in a desktop web browser. Menu labels and layout can vary slightly as Google updates the interface, but the sorting command is in the filter menu for the relevant column.

Select the range containing the headers and complete rows you want to organize.
Choose Data > Create a filter. Filter icons appear in the header cells.
Click the filter icon in the column whose cells have the color you want to use.
Choose Sort by color, then choose Fill color or Text color.
Select the color shown in the menu. Sheets groups the rows according to that color.

After sorting, inspect the results to confirm that the intended rows moved together and that the range did not omit any columns. To remove the filter controls, choose Data > Remove filter. Removing the filter is different from undoing the sort: it hides the filter icons but does not restore the old row order. Use Edit > Undo promptly if you need to reverse a recent sort; otherwise, sort by another field or restore an earlier version if available.

Fill color, text color, and conditional formatting

Fill color is the background color of a cell; text color is the color of the characters inside it. Choose the one that actually communicates the category in your sheet. A table might use a colored background for priority but black text throughout, in which case Fill color is the relevant option. If every cell has the same background but labels use red, blue, and green text, choose Text color instead.

Conditional formatting changes a cell’s appearance when its value meets a rule. This can be handy when colors are generated automatically—for example, a date cell turns red when it is past due. If the color appears in the Sort by color menu, you can select it there; check the resulting groups rather than assuming that a manually chosen fill and a rule-generated color are being treated identically in every situation. The rule itself remains in place when rows move, and its appearance may update if the rule depends on values or relative positions.

When color is important to the meaning of the data, do not make it the only signal. A label such as Overdue or Complete makes the category clearer to people who cannot distinguish the colors and gives you a dependable field to filter, sort, or summarize.

Color order and sorting by more than one condition

A color sort is best understood as a way to bring a chosen color group together, not as a full custom priority system. If you need the exact order red, then yellow, then green, a single color-based sort may not provide a way to define that three-color sequence. Repeating color sorts is not a dependable substitute for specifying a complete order, because each new sort can change the arrangement created by the previous one.

For a defined sequence, add a category or priority column with explicit values. For example, enter 1 for urgent, 2 for upcoming, and 3 for complete, then sort by that column. You can keep the colors as visual cues while using the values to control order. This also makes the intended ranking obvious to anyone who opens the file.

Sorting by color and sorting by a value are separate operations. If you need color groups and then an order within each group, first decide whether that order needs to be preserved and test the process on a copy. For recurring reports, a helper column is usually easier to explain and repeat than a sequence of manual formatting-based sorts.

Common problems and how to fix them

Sort by color is missing. Confirm that you created a filter and opened the filter icon for the column that contains the colored cells. A normal column heading menu or a selected cell’s context menu is not the same menu.
Only one column moved. Undo if possible, then select the full table and create the filter again. Sorting an incomplete selection can separate values that belong in the same record.
The wrong cells are grouped. Check whether the color is a fill or a font color, and make sure you opened the menu for the correct column. Look for conditional formatting rules that may be changing the displayed color.
Some records are not included. Expand the selected range to include all records. Blank rows, separate tables, or data added after the filter was created can make it less obvious what is included.
The colors do not create the priority order expected. A color is a visual format, not a complete ranking scheme. Add a priority or status field when you need a precise, repeatable order.

If a filter is active and the sheet looks incomplete, remember that filtering can hide rows as well as sorting them. Open the relevant filter menu and check whether a value or color filter is restricting what is visible before concluding that records have disappeared.

Alternatives for repeatable organization

For occasional cleanup, sorting by color is convenient. For work that happens every week or needs to be audited, store the meaning of the color in the data. A status column with values such as Not started, In progress, and Complete can be sorted alphabetically, filtered, or used in reports. If the desired order is not alphabetical, use a separate numeric priority column.

You can also use a filter to display only records with a particular color rather than rearranging the full table. In the column filter menu, look for Filter by color and choose the relevant fill or text color. This is useful when you want to review urgent items without changing the order of the underlying rows. Clear the filter when you want to see all records again.

Another option is to sort by the actual value that drives conditional formatting. If a red fill is produced by a rule for dates earlier than today, sorting by the date field can often provide a more meaningful order than sorting by the resulting red appearance. Choose the approach that matches the question: color is suitable for a quick visual grouping; a value or helper field is better for a defined, reusable workflow.

Google Sheets compared with Excel

Google Sheets and Microsoft Excel both offer ways to sort by cell color, but their menu paths and controls are not identical. In Sheets, the common route is Data > Create a filter, followed by Sort by color in a column’s filter menu. In Excel for Microsoft 365 on Windows, color sorting is available through the Sort dialog, where the sort settings can use cell color or font color. Do not follow Excel instructions for the Sheets interface, or assume that a control in one program has the same name or location in the other.

If a spreadsheet is shared between the programs, check how its formatting and sort order appear after opening it in the other application. A sort changes row order in the shared data, while a filter can affect which rows a viewer sees. Coordinate substantial changes with collaborators, especially in a shared sheet, and consider making a copy before reordering a table that others rely on.

Frequently Asked Questions

Can Google Sheets sort by cell color without a filter?
Use Data > Create a filter first, then open the filter menu for the colored column and choose Sort by color. The filter menu is the normal route to the color-sorting command.

Can I sort by both fill color and text color?
You can choose Fill color or Text color as the basis for a color sort. If you need multiple conditions or a precise ranking across several colors, add explicit category or priority values and sort by those instead.

Can Google Sheets sort by a conditional formatting color?
If the rule-generated color is offered in the Sort by color menu, you can select it. Verify the result, since the color is the visual outcome of a rule and may change when values or rule conditions change.

Does sorting by color change the cell values?
No. It rearranges rows based on formatting; it does not replace the text, numbers, or dates in the cells. Ensure the selected range includes the full records so related values stay together.

Can I sort colors in a custom order, such as red, yellow, then green?
Do not rely on a single color sort to define an arbitrary multi-color sequence. Add a priority column with an explicit order, then sort by that field for consistent results.

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.