Denise,
I have just completed a "macro thingy" that does what you want.
It is an Excel add-in ("Special Sort") that provides nine additional sort options...
color - font color or cell color
text with numbers in numerical sequence
just the numbers in the text
length of text
text in reverse
date - day, month, year or day of week
excluding leading articles (a, an, the)
text before a specified separator
text after a specified separator
There is an option to include borders with the sorted cells.
It looks and acts somewhat like the regular Excel sort utility.
..
Comes with a two page Word.doc install/use file.
Available -free- upon direct request.
Remove XXX from my email address.
Regards,
Jim Cone
San Francisco, USA
XX
"Denise Robinson" wrote in message
...
Hi all
I have a large database (23,000 rows) and many of the rows have coloured
backgrounds as a form of coding to myself.
Is there anyway you can sort by fill colour?
eg. 1000 are Red to indicate No interest and I want to easily delete them in
one go rather than scrolling through 23,000 and deleteing individually.
I have a feeling someone will suggest writing a Macro thingy which I'm
afraid my brain will not be able to cope with!
Thank you
Denise