|
|
|
|
|
How to sort Excel sheet according to font color
Microsoft Excel allows you to sort your data in a number of different and custom ways, let's learn how to sort Excel data according to the color of the fonts.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
Select the sheet data that has different font colors in its cells.
Also recommended:
|
|
| |
2.
|
|
|
In the Toolbar above, while Home tab being active, click Sort & Filter and choose Custom Sort...
|
|
| |
3.
|
|
|
Choose the Column you want to sort your data by ...
The one with different colored fonts.
|
|
| |
4.
|
|
|
... choose Font Color for the Sort On option ...
|
|
| |
5.
|
|
|
... choose the font color you want to sort by first and click OK.
|
|
| |
6.
|
|
|
That's it, your Excel data should now be sorted by the font colors.
Also recommended:
|
|
|
 |
|
|
|
Fill every other row with color
