PDA

View Full Version : Sleeper: Sort columns by cell color



ermis1975
08-31-2005, 03:46 PM
Maybe with color index value?

geekgirlau
08-31-2005, 05:00 PM
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
08-31-2005, 05:07 PM
There is also some good stuff here .. http://www.cpearson.com/excel/SortByColor.htm .. at Chip Pearson's site.