Sort by column Color

Eric · Aug 10, 2004

Can anyone be so kind to advise me how i can sort the column color in excel.

I have spreadsheet of 100 records and some are coloured to identify for
certain indentities.. I want to sort them.. can anyone enlighten me

Eric

Chip Pearson · Aug 10, 2004

Eric,

You need a custom VBA function to return the color index to a
cell, and then sort on that column. See
http://www.cpearson.com/excel/sortbycolor.htm for details and
example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com