Ever found yourself scrolling through a document in Google Sheets, wishing you could quickly sort items based on their color, font specifically? While Google Sheets doesn't offer a direct sort function for font color, you can use several workarounds to achieve this. In this guide, we'll explore two effective methods to sort by font color in Google Sheets.

Before we dive in, ensure your data is formatted as cells containing text. If your data is in columns, it's a good idea to transpose it into rows for easier sorting. Now, let's get started!

Method 1: Using Conditional Formatting
Conditional formatting allows you to apply specific rules to cells, including formatting. By utilizing this feature, we can apply colors based on the font color in the cells and then sort accordingly.

First, let's add conditional formatting to the cells with colored fonts. Here's how:
Step 1: Identify the font color

Choose a cell with the font color you want to sort by. Right-click the cell and select "Format cells" from the drop-down menu.
Step 2: Apply conditional formatting
In the Format cells dialog box, click on the 'Conditional formatting' tab. Select 'Format cells if...' and then click on 'Custom formula is...'. In the 'Custom formula' field, enter '=B1=COLOR10' (replace 'B1' and 'COLOR10' with your reference cell and desired color code, respectively). Click 'Done'.

Repeat the process for each font color you want to sort by, using distinct color codes each time (e.g., '=B1=COLOR6' for a different font color).
Now, you should see your cells adopting a new background color based on their font color.
Step 3: Sort your data

After applying the conditional formatting, go to 'Data' in the menu and click 'Sort A→Z' (or 'Sort Z→A') to sort your data based on the background color.
Note that this method works best when your font colors are distinct and won't cause overlapping in the sorting process.




















Method 2: Using REGEXMATCH
If you prefer a more direct approach, you can use Google Sheets' built-in functions like REGEXMATCH and CONCATENATE to create a new column for sorting. This method requires a bit of text manipulation but can be more efficient with large datasets.
Here's how to do it:
Step 1: Create a helper column
Add a new column (e.g., Column C) next to the data you want to sort. In the first cell, enter the following formula: `=REGEXMATCH(A2,regexreplace(translate(A2,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","abcdefghijklmnopqrstuvwxyz"),"[[:alnum:]]",""))`.
Step 2: Create a sorted column
In the next cell (e.g., A3), enter the following formula: `=ARRAYFORMULA(IF(C2:C=TRUE,ROW(A2:A)-1,""))`. Drag this formula down to apply it to the entire column.
This will create a new column with sort orders based on the font colors. You can now sort your data based on this column.
Remember to delete the helper column once you're done. The sorted data will remain in their new positions.
Using these methods, you can effectively sort by font color in Google Sheets, making your data manipulation tasks easier and more efficient. Happy sorting!