Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering by Colour
HI I have a worksheet of 650 rows. Certain of the rows are highlighted in green. How can I group the highlighted rows at the top of the sheet? Grateful for any advice. Best Wishes |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering by Colour
In an adjacent column you can add a code (like G for green) against
each of those highlighted cells. Then if you want to filter it (which is what your heading suggested) you can apply a filter to this helper column. If you want to group those highlighted cells together, then you can sort the data plus the helper column, using the helper column as the sort key, and then all the G's will be bunched together, with the blank cells below. Hope this helps. Pete On Sep 25, 1:06*am, Colin Hayes wrote: HI I have a worksheet of 650 rows. Certain of the rows are highlighted in green. How can I group the highlighted rows at the top of the sheet? Grateful for any advice. Best Wishes |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering by Colour
Check this out:
http://www.cpearson.com/excel/SortByColor.htm regards, Ryan-- -- RyGuy "Pete_UK" wrote: In an adjacent column you can add a code (like G for green) against each of those highlighted cells. Then if you want to filter it (which is what your heading suggested) you can apply a filter to this helper column. If you want to group those highlighted cells together, then you can sort the data plus the helper column, using the helper column as the sort key, and then all the G's will be bunched together, with the blank cells below. Hope this helps. Pete On Sep 25, 1:06 am, Colin Hayes wrote: HI I have a worksheet of 650 rows. Certain of the rows are highlighted in green. How can I group the highlighted rows at the top of the sheet? Grateful for any advice. Best Wishes |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering by Colour
Also Excel 2007 has that ability using autofilter
-- Regards, Peo Sjoblom "ryguy7272" wrote in message ... Check this out: http://www.cpearson.com/excel/SortByColor.htm regards, Ryan-- -- RyGuy "Pete_UK" wrote: In an adjacent column you can add a code (like G for green) against each of those highlighted cells. Then if you want to filter it (which is what your heading suggested) you can apply a filter to this helper column. If you want to group those highlighted cells together, then you can sort the data plus the helper column, using the helper column as the sort key, and then all the G's will be bunched together, with the blank cells below. Hope this helps. Pete On Sep 25, 1:06 am, Colin Hayes wrote: HI I have a worksheet of 650 rows. Certain of the rows are highlighted in green. How can I group the highlighted rows at the top of the sheet? Grateful for any advice. Best Wishes |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering by Colour
As well as using Sort.
Bob Umlas "Peo Sjoblom" wrote in message ... Also Excel 2007 has that ability using autofilter -- Regards, Peo Sjoblom "ryguy7272" wrote in message ... Check this out: http://www.cpearson.com/excel/SortByColor.htm regards, Ryan-- -- RyGuy "Pete_UK" wrote: In an adjacent column you can add a code (like G for green) against each of those highlighted cells. Then if you want to filter it (which is what your heading suggested) you can apply a filter to this helper column. If you want to group those highlighted cells together, then you can sort the data plus the helper column, using the helper column as the sort key, and then all the G's will be bunched together, with the blank cells below. Hope this helps. Pete On Sep 25, 1:06 am, Colin Hayes wrote: HI I have a worksheet of 650 rows. Certain of the rows are highlighted in green. How can I group the highlighted rows at the top of the sheet? Grateful for any advice. Best Wishes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |