LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Denise Robinson
 
Posts: n/a
Default Sorting by Fill Colour

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to fill colour in Excel, it appers No fill in my computer? bede Excel Discussion (Misc queries) 1 June 11th 05 03:27 AM
Fill colour red Dave Excel Discussion (Misc queries) 2 May 14th 05 12:08 PM
Can I fill colour in a excel cell from a return from an "IF" test. williamw Excel Worksheet Functions 1 March 24th 05 10:31 AM
- colour fill in excel tatiana Excel Discussion (Misc queries) 1 March 13th 05 12:30 PM
Sum cells according to colour fill JanB Excel Discussion (Misc queries) 1 February 2nd 05 11:21 PM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"