Is it possible to sort cells in shades of colors?

excelledsoftware · #2 01-31-2014, 06:40 PM

Yes but you need to do it with VBA. Basically each of those colors has a color index # that you can sort by. You could use this code.

Code:

Sub FillColorIndex()
    'Takes the index of a color and places it in the cell next to the data
        Dim ColorRow As Integer, TotalRows As Integer
        
            TotalRows = WorksheetFunction.CountA(Range("b:b").Rows)
            
            For ColorRow = 2 To TotalRows
                Range("d" & ColorRow).Value = Range("b" & ColorRow).Interior.ColorIndex
            Next ColorRow
            
            MsgBox "All Rows Complete"

End Sub

That will give you a number for each of the colors. Now I am guessing that you want each of those colors to grouped ie. Reds with reds, blues with blues etc. The colorindex will not quite do that but you can sort the numbers and change them as you wish to sort them after.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Sort Table Cells from Left to Right	tamaracklodge	Word Tables	4	03-04-2013 04:00 AM
Unable to change font colors from theme colors	choy	Word	3	08-01-2012 09:12 PM
Auto Colors in Cells?	Learner7	Excel	5	07-06-2010 10:55 PM
How can I change the colors of cells automatically based on Job Completion?	Learner7	Excel	0	07-06-2010 10:47 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM