Can I sort excel spreadsheet data by fill color of cells?

[Guest]

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?

 

[Gord Dibben]

You could use Conditional Formatting to color the cells.

Then you can sort by the condition that caused the color change.

Excel won't natively sort by color or formatting.

To do so you need VBA code.

See Chip Pearson's site for more.

http://www.cpearson.com/excel/colors.htm

http://www.cpearson.com/excel/SortByColor.htm


Gord Dibben Excel MVP

 

[Jim Cone]

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
(e-mail address removed)


"Fashionheadhunter"
<[email protected]>
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?