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

Only through the use of VBA

See Chip Pearson's "Sortbycolor" code.

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


Gord Dibben MS Excel MVP


On Tue, 16 Oct 2007 14:36:02 -0700, Steve Vincent
wrote:

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

see:
http://www.cpearson.com/excel/SortByColor.htm
--
Gary''s Student - gsnu200750

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

On Oct 16, 10:36 pm, Steve Vincent
wrote:
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

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

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

Steve