Sorting by colors
 

Is it possible to sort by the fill-in color in Excel? I do a lot of
highlighting rows, etc. and it would be so much easier than having to cut and
paste.
--
Thanks!
Heather

Sorting by colors
 

Get the colorindex in a separate column with the following UDF

Function GetCI(rng As Range) As Long
GetCI = rng.Interior.Colorindex
End Function

in the cell, =GetCI(A2)

and then sort on that new column of CIs.


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Heather" wrote in message
...
Is it possible to sort by the fill-in color in Excel? I do a lot of
highlighting rows, etc. and it would be so much easier than having to cut
and
paste.
--
Thanks!
Heather