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?

Sort by color?
 

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

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?

Sort by color?
 

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
HIS


"Bud" wrote in message
...
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?

Sort by color?
 

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

--
HTH

Bob Phillips

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

"Bud" wrote in message
...
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?