LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Fashionheadhunter
 
Posts: n/a
Default Can I sort excel spreadsheet data by fill color of cells?

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 09:01 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"