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.

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" wrote in message
...
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" schrieb im Newsbeitrag
...
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.