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