Did you read all the page?

Using Chip's Functions you can sort by cell color OR by font color.

Have another look at the part that states........

If you want to sort by the Font color of the cell, use the formula

=ColorIndexOfCell(A1,TRUE,TRUE)



Gord Dibben Excel MVP

On Thu, 2 Jun 2005 17:29:35 -0500, PokerZan
wrote:


Thank you, but I am not sorting by cell color but color of text.