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
.