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?