data sort by highlighted or coloured cell

[Guest]

does anyone know if this is possible... rather unconveniently a person has
highlighted in red about 400/500 or so rows within a 12,000 row data spread.
Apart from thinking how long that must of taken I know need to sort these, is
there a way that anyone knows? I've tried looking into conditional formating
and data sorting but couldn't find anything. Otherwise it's a trawl through
the spreadsheet for me... thanks, A.

 

[Paul B]

aplex, see if this will help http://www.cpearson.com/excel/SortByColor.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/SortByColor.htm