|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2010, 04:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort 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
May 15th, 2010, 06:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sort by Colour
hi
see this site for a short tutorial on how to do that http://www.datapigtechnologies.com/f...rtonColor.html this site has other color functions like sum by color, count by color, others. http://cpearson.com/excel/colors.aspx Regards FSt1 "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
May 16th, 2010, 03:28 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sort by Colour
In article , FSt1
writes hi see this site for a short tutorial on how to do that http://www.datapigtechnologies.com/f...rtonColor.html this site has other color functions like sum by color, count by color, others. http://cpearson.com/excel/colors.aspx Regards FSt1 HI OK Thanks for that - solved my problem. I went a little further too and saved it as an addin , so it will always be loaded on startup. It works a treat. Best Wishes "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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
