Grouping by Colour

[AJ]

I've highlighted a number of rows by red, green, and blue.

Is it possible to sort the spreadsheet out by colour?, so
that all the blue Rows are at the top, followed by the Red
rows, and then the green Rows?

Many thanks,

AJ

 

[Andy B]

AJ

Try Chip's site:
http://www.cpearson.com/excel/SortByColor.htm

Andy.

 

[AJ]

Hi there,

Many thanks for the link.

Unfortunately, I've never used VB before, and have no idea
how to implement the 'code'.

Is there a formula which can convert a coloured cell into
some sort of hexidecimal? - I could then sort the hex into
an ascending order, and at least that would put the
colours into batches.

Many thanks,

AJ

 

[Andy B]

AJ

Your best bet is to simply copy the code from the web (select it and use
Ctrl C). Right click on your sheet tab (at the bottom of the sheet) and
paste (Ctrl V) the code in. To run the code, go to Tools/Macro/Macros and
then select the macro and click Run

Andy.

 

[Dave Peterson]

You may want to read David McRitchie's overview:
http://www.mvps.org/dmcritchie/excel/getstarted.htm