Sort by Colour

[Colin Hayes]

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

 

[FSt1]

hi
see this site for a short tutorial on how to do that
http://www.datapigtechnologies.com/flashfiles/SortonColor.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]

hi
see this site for a short tutorial on how to do that
http://www.datapigtechnologies.com/flashfiles/SortonColor.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