Is it possible to sort cells in shades of colors?

excelledsoftware · #1 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.

jolivanes · #2 02-01-2014, 01:04 AM

If you're happy with RGB sorting?
See attached

gasyoun · #3 02-01-2014, 02:11 AM

Quote:

Originally Posted by excelledsoftware

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.

There are 24k colors. Do I understand you right, that you propose to sort them manually? Even RGB gives you blue that can look like grey, because of the intensity. Can color and color intensity be taken into account? I'm a big fan of manual labor in Excel. But 24 000 rows is too many even for me.

http://labs.tineye.com/color/001c85d...True&height=32 does an interesting job, but still no enough.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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