sort by color

Is there a formula that will allow me to sort a column based on the background color?

Thanks,
Jaime

Not a formula, but there is a technique here
http://www.xldynamic.com/source/xld....r.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jegal76" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a formula that will allow me to sort a column based on the
> background color?
>
> Thanks,
> Jaime
>
>
> --
> jegal76
> ------------------------------------------------------------------------
> jegal76's Profile:
http://www.excelforum.com/member.php...o&userid=28077
> View this thread: http://www.excelforum.com/showthread...hreadid=475833
>

Jaime,

My Excel add-in "Special Sort" will sort by font color or cell color.
It provides 12 different ways to sort not available in the Excel sort utility.
Comes with a Word.doc install/use file.
It is free upon email request - remove XXX from my email address.

Jim Cone
San Francisco, USA
[email protected]XX

"jegal76"wrote in message
news:[email protected]
Is there a formula that will allow me to sort a column based on the
background color?
Thanks,
Jaime

Not a formula. See here
http://www.xldynamic.com/source/xld....r.html#sorting for a
technique

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jegal76" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a formula that will allow me to sort a column based on the
> background color?
>
> Thanks,
> Jaime
>
>
> --
> jegal76
> ------------------------------------------------------------------------
> jegal76's Profile:
http://www.excelforum.com/member.php...o&userid=28077
> View this thread: http://www.excelforum.com/showthread...hreadid=475833
>