Quick way to sort lists by text color?

[PokerZan]

Ok, some genious sent me a spreadsheet with thousands of rows that
need to extract and sort out all text that is red. Is there a way t
sort to maybe do an if/then formula in an additional column to inpu
some text to do a quick sort on that

 

[JE McGimpsey]

Take a look here:

http://cpearson.com/excel/SortByColor.htm

 

[PokerZan]

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

 

[Gord Dibben]

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