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

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
.

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
.

try this fancy excel add in.

http://www.digdb.com/excel_add_ins/s..._length_color/

all the best