Sort by Colour?
 

Is it possible to sort a spreadsheet by the background colour of a cell?

I could do it using code but am interested if there is an easier way.....

Cheers,

Steve.

See www.cpearson.com/excel/sortbycolor.htm for a procedure to
sort by color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"FBxiii" wrote in message
...
Is it possible to sort a spreadsheet by the background colour
of a cell?

I could do it using code but am interested if there is an
easier way.....

Cheers,

Steve.

hi,
no easier way.
se pj456's post about 5 posts down form your post.
Regards
Frank
-----Original Message-----
Is it possible to sort a spreadsheet by the background
colour of a cell?

I could do it using code but am interested if there is an
easier way.....

Cheers,

Steve.
.

Cheers,

I did actually see that post after i entered mine :/

I had a feeling it would need coding.

Thanx anyway,

Steve.


"Frank Stone" wrote:

hi,
no easier way.
se pj456's post about 5 posts down form your post.
Regards
Frank
-----Original Message-----
Is it possible to sort a spreadsheet by the background
colour of a cell?

I could do it using code but am interested if there is an
easier way.....

Cheers,

Steve.
.