data sort by highlighted or coloured cell

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.

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

--
Regards
Frank Kabel
Frankfurt, Germany
"aplex" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> 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.

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

"aplex" <[email protected]> wrote in message
news:[email protected]...
> 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.