Sort by color?

[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?

 

[Guest]

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

 

[Nick Hodge]

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)

 

[Bob Phillips]

See http://xldynamic.com/source/xld.ColourCounter.html#sorting

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)