Sorting
 

I have been asked if it is possible to sort by cell backgrournd colour. Can
anyone help

Thanks
Bac

Sorting
 

Yes Bac,

it's possible, but you need a macro Chip Person has it at

http://www.cpearson.com/excel/SortByColor.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"bac" escreveu:

I have been asked if it is possible to sort by cell backgrournd colour. Can
anyone help

Thanks
Bac

Sorting
 

You need a cheater column and a User-Defined-Function to do that in XL2000.
I've heard you can do it in XL2003 but don't know.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"bac" wrote:

I have been asked if it is possible to sort by cell backgrournd colour. Can
anyone help

Thanks
Bac

Sorting
 

No change in Excel 2003


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 13:41:01 -0700, Gary L Brown
wrote:

You need a cheater column and a User-Defined-Function to do that in XL2000.
I've heard you can do it in XL2003 but don't know.
HTH,