Sort by font format

[Steve Vincent]

I have a user who has formatted cells in different shade/backfill colors or
by other font attributes (e.g., bold) for different reasons, and now wants to
sort (effectively, grouping) by those formats. Can this be done?

TIA,

Steve Vincent
[email protected]

 

[Gord Dibben]

Only through the use of VBA

See Chip Pearson's "Sortbycolor" code.

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


Gord Dibben MS Excel MVP

 

[Pete_UK]

This link explains how you can sort by colour:

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

Essentially, you will need a user-defined function to be able to
return the colour (or other) attribute into another column and then
sort by that column.

Hope this helps.

Pete

 

[Jim Cone]

Excel 2007 can sort by color. However, that version is still under construction.
The commercial Excel add-in "Special Sort" (from yours truly) can sort by font
color or by cell interior color... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA
(Excel Add-ins / Excel Programming)


"Steve Vincent"
wrote in message
I have a user who has formatted cells in different shade/backfill colors or
by other font attributes (e.g., bold) for different reasons, and now wants to
sort (effectively, grouping) by those formats. Can this be done?
TIA,
Steve Vincent
[email protected]

 

[Steve Vincent]

Thanks to all of you for your input! Right on the money.

Steve