Grouping by Colour

  • Thread starter Thread starter AJ
  • Start date Start date
A

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
 
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
 
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.
 
Back
Top