Sort by column Color

[Eric]

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]

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