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

On Tue, 6 Sep 2005 17:08:22 -0700, "Fashionheadhunter"
wrote:

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?