LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bud Bud is offline
external usenet poster
 
Posts: 1
Default Sort by color?

I have a spreadsheet 8 columns wide and 400+ rows long. Someone has
highlighted (set Pattern color) some of the rows (always a whole row
.... not just some cell in the row) in yellow. I want to sort the
spreadsheet so that all the yellow rows appear at the top of the list
sorted on column C (primary) and A (secondary). How would this be
done?
 
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
Sort or sub-total by Fill color or font color Excel_seek_help Excel Discussion (Misc queries) 1 April 27th 06 09:01 PM
sort by highlite color Cpfd-df Excel Worksheet Functions 1 December 6th 05 11:25 PM
Sort columns by color danpajo Excel Discussion (Misc queries) 1 September 1st 05 05:08 AM
Can you sort excel data by color coded cells? lbs Excel Discussion (Misc queries) 2 August 3rd 05 03:00 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM


All times are GMT +1. The time now is 04:48 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"