Maybe with color index value?
Maybe with color index value?
Sorting only works on a value. To get around this you could create a custom function to capture the color index of a cell in a hidden column, then sort by this column.
Function SortColour(rng As Range) As Variant SortColour = rng.Interior.ColorIndex End Function
Your formula in the sort column would be "=SortColour(A2)"
There is also some good stuff here .. http://www.cpearson.com/excel/SortByColor.htm .. at Chip Pearson's site.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables