Sort by Colour?

[FBxiii]

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.

 

[Chip Pearson]

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

 

[Frank Stone]

hi,
no easier way.
se pj456's post about 5 posts down form your post.
Regards
Frank

 

[FBxiii]

Cheers,

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

I had a feeling it would need coding.

Thanx anyway,

Steve.