Sort by color?

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

--
paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!



"Bud" wrote:

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

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Bud" <trueblueS_P_A_M__F_O_I_L_E_R@zorklabs.com> wrote in message
news:m3jea2ds4mncfj3ds06f15i6viv4sn0d65@4ax.com...
>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?

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

--
HTH

Bob Phillips

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

"Bud" <trueblueS_P_A_M__F_O_I_L_E_R@zorklabs.com> wrote in message
news:m3jea2ds4mncfj3ds06f15i6viv4sn0d65@4ax.com...
> 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?