I have a 3000 row sheet that I would like to sort by colour..so that
the rows filled in with pink show at the top of the sheet.

Can this be done?

....Lisa

See Chip Pearson's site for info and code.

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


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 16:58:42 -0700, "
wrote:

I have a 3000 row sheet that I would like to sort by colour..so that
the rows filled in with pink show at the top of the sheet.

Can this be done?

...Lisa

Lisa,

VBA code is required to color sort, unless you want to go thru the
pain of installing and trying to use XL2007.
These two web sites provide code to sort by color...
http://www.xldynamic.com/source/xld.ColourCounter.html
http://www.cpearson.com/excel/colors.htm
-or-
There are some commercial applications (add-ins) that provide
color sorting capability to Excel.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins: sorting, comparing, matching, listing, finding...)




wrote in message
I have a 3000 row sheet that I would like to sort by colour..so that
the rows filled in with pink show at the top of the sheet.

Can this be done?
....Lisa

Thanks Gord

VBA is beyond me right nowOn Jul 12, 8:34 pm, Gord Dibben
<gorddibbATshawDOTca wrote:
See Chip Pearson's site for info and code.

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

Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 16:58:42 -0700, "

wrote:
I have a 3000 row sheet that I would like to sort by colour..so that
the rows filled in with pink show at the top of the sheet.

Can this be done?

...Lisa

Thanks Jim...I might look into other add-ins

....Lisa

On Jul 12, 8:42 pm, "Jim Cone" wrote:
Lisa,

VBA code is required to color sort, unless you want to go thru the
pain of installing and trying to use XL2007.
These two web sites provide code to sort by color...http://www.xldynamic.com/source/xld....cel/colors.htm
-or-
There are some commercial applications (add-ins) that provide
color sorting capability to Excel.
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins: sorting, comparing, matching, listing, finding...)


wrote in message
I have a 3000 row sheet that I would like to sort by colour..so that
the rows filled in with pink show at the top of the sheet.

Can this be done?
...Lisa