Sorting by colors

  • Thread starter Thread starter Heather
  • Start date Start date
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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can you sort an Excel table by the color a row is shaded? 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Sort a Spreasheet by Color Highlights? 2
sorting spreadsheet rows by color 1
Sort by color: Is there an easy way to sort columns or rows in EX 5
Excel Macro to automatically go to the right of the last colored cell 0
Can you sort a column in Excel that's different by colored font? 1
highlight subtotal rows with a fill color 1

Back
Top