Sort by color?

  • Thread starter Thread starter Bud
  • Start date Start date
B

Bud

I have a spreadsheet 8 columns wide and 400+ rows long. Someone has
highlighted (set Pattern color) some of the rows (always a whole row
.... not just some cell in the row) in yellow. I want to sort the
spreadsheet so that all the yellow rows appear at the top of the list
sorted on column C (primary) and A (secondary). How would this be
done?
 
if the colour has been set by hand someone will post a link for you,if the
colour has been set by conditional format you can set a new column to the
same formula or condtion and sort by that then C then A
 
Bud

You could copy this UDF to a standard module in the workbook, duplicate the
colour you want to sort by, say in A1 and then using that as a pattern, set
up a helper column alongside your data. This will give you a number on
which to sort

Function ColourNumber(ColourCell As Range) As Long
Application.Volatile True
ColourNumber = ColourCell.Interior.ColorIndex
End Function

Applied as

=ColourNumber($A$1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top