is it possible to sort a range of cells in excel by color font?

Question

thx for help

Answer 1

You'd have to use vba.

Answer 2

Create a macro and copy and paste the following code...

Function ColorRank(ColorOrder As Range, LookCell As Range)
'''''''''''''''''''''''''''''''''''''''''''''
'Ranks a list of Colors so they can be sorted
'''''''''''''''''''''''''''''''''''''''''''''

Dim i As Integer
Dim ICol1 As Integer
Dim ICol2 As Integer

i = 1
ICol2 = -1
ColorRank = 0

'Loop until match is found
Do Until ICol1 = ICol2
'Replace "Interior" with Font to sort by Font color
ICol1 = ColorOrder(i, 1).Interior.ColorIndex
ICol2 = LookCell.Interior.ColorIndex
If i = ColorOrder.Rows.Count + 1 Then
'No Match found place in Text
ColorRank = "No colour match!!!"
Exit Do
End If
'Pass the Row number of the colour match
ColorRank = i
i = i + 1
Loop
End Function