Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort or sub-total by Fill color or font color | Excel Discussion (Misc queries) | |||
sort by highlite color | Excel Worksheet Functions | |||
Sort columns by color | Excel Discussion (Misc queries) | |||
Can you sort excel data by color coded cells? | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) |