Sorting by colors

H

Heather

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.
 
B

Bob Phillips

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