LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Jim Cone
 
Posts: n/a
Default

Excel cannot sort by color, however my Excel add-in
"Special Sort" - rel 1.31, should do what you want.

It adds 11 sort features not found in Excel, including sorting by..
Prefix, Suffix or Middle (where you specify the length/position).
Will also sort by color, dates, number group, length, reverse,
random and others.
Comes with a 2 page install/use Word file.
It is available - free - upon direct request.
Remove XXX from my email address.

Regards,
Jim Cone
San Francisco, USA
XX


"Fashionheadhunter"

wrote in message

I have a spreadsheet with data in about 1,000 cells. I occasionally
highlight cells by adding yellow color fill to make them standout. I would
like to sort the data so that I could move the "highlighted" cells to the top
of the sheet. Can this be done? If not, can you suggest a way to accomplish
this in the future--ie., use a different font, boldface, etc. that would
allow me to sort easily?
 
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 column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. wdking Excel Worksheet Functions 0 January 18th 05 03:43 PM
copying data from Excel spreadsheet to another DavidB Excel Discussion (Misc queries) 1 January 10th 05 11:26 PM
Can you sort Excel data by font color? Help Me Sort Excel Discussion (Misc queries) 2 December 21st 04 10:35 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


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