Sleeper: Sort columns by cell color

[ermis1975]

Maybe with color index value?

[geekgirlau]

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)"

[Zack Barresse]

There is also some good stuff here .. http://www.cpearson.com/excel/SortByColor.htm .. at Chip Pearson's site.