Quick way to sort lists by text color?
 

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


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=376116

Take a look he

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

In article ,
PokerZan
wrote:

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

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


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=376116

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.