Quick way to sort lists by text color?

P

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
 
G

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
 
Top