Diane
Depends upon how the cells received their color format. If by using
Conditional Formatting, the same conditions could be used to sort.
If manually colored, you will need VBA. See Chip Pearson's site for details
and code.
http://www.cpearson.com/excel/SortByColor.htm
Be sure to read the NOTE: on Conditional Formatting at bottom of page.
Gord Dibben Excel MVP - XL97 SR2 & XL2002
