Sort by font color

Application: Spreadsheet Home Edition

Sorting by font color is available if a font color other than the default one is specified for at least one cell in the range.

Sort selected range

Sorting the selected range by font color is only available using the custom sorting.

To sort the selected range by font color, follow the steps below:

1.Select the cell range for which you want to perform sorting.

2.Open the Custom sorting window in one of the following ways:

•On the Home tab, in the Data group, click the arrow to the right of the t_data_sorting Sort button. In the drop-down list, select Custom sorting.

•On the Data tab, click the arrow to the right of the t_data_sorting Sort button. In the drop-down list, select Custom sorting.

•Right-click any cell in the selected range and select Sort > Custom sorting.

•Press Ctrl+Shift+R (Windows, Linux) or ⌘Cmd+⇧Shift+R (macOS).

3.In the Custom sorting window:

•Select the Columns have titles checkbox if you want to use the values of the upper cells as column titles. Titles will not be part of the sorting.

•In the Column column, select the name of the column you want to sort by from the drop-down list.

•In the Sort column, select By font color from the drop-down list.

•In the Order column, select the sort order: To top or To bottom: cells with the selected font color will be moved to the top or bottom of the selected column. The remaining cells in the column, will be placed below or above these cells.

•In the Color column, select the font color from the proposed set.

4.At the bottom of the window, click Apply.

Sort the sort and filter range

To sort the sort and filter range by font color, follow these steps:

1.Click the editor_filter_on_drop_active button in the upper cell of the column you want to sort by.

2.In the Sort and filter window, in the Sort type drop-down list, select By font color.

3.Select the sort order using the side_panel_defined_names_sorting To top or t_data_sorting To bottom options. Cells with the selected font color will be moved to the top or bottom of the selected column, respectively. The remaining cells in the column, will be placed below or above these cells.

4.Select the font color from the proposed set. The selected color will be ticked.

5.At the bottom of the window, click Apply.

The appearance of the sort and filter button may differ from the one shown here because it depends on whether sorting has been applied before, the sort order (ascending or descending), and whether a filter has been applied:

– editor_filter_on_drop_active : No sorting or filtering applied.

– filter_applied : Filter applied, no sorting applied.

– sorting_ascending_icon : Sorted in ascending order with no filter applied.

– sorting_descending_icon : Sorted in descending order with no filter applied.

– sorting_ascending_filter_icon : Sorted in ascending order with filter applied.

– sorting_descending_filter_icon : Sorted in descending order with filter applied.

You can also sort the sort and filter range by font color using custom sorting. To do this, proceed as follows:

1.Click the editor_filter_on_drop_active button in one of the top cells of the range.

2.In the Sort and filter window, in the Sort type drop-down list, select Custom sorting.

3.In the Custom sorting window:

•In the Column column, select the name of the column you want to sort by from the drop-down list.

•In the Sort column, select By fill color from the drop-down list.

•In the Order column, select To top or To bottom sort order. Cells with the selected fill color will be moved to the top or bottom of the selected column, respectively. The remaining cells in the column, will be placed below or above these cells.

•In the Color column, select the fill color from the proposed set.

4.At the bottom of the window, click Apply.

Was this helpful?

Yes