Sort by Fill Color
 

Hello,

Is it possible to sort cells by fill colors without writing VBA? I'm using
Excel version 2003
--
Thank you... Elaine

Sort by Fill Color
 

See http://xldynamic.com/source/xld.Colo...r.html#sorting

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Elaine" wrote in message
...
Hello,

Is it possible to sort cells by fill colors without writing VBA? I'm using
Excel version 2003
--
Thank you... Elaine

Sort by Fill Color
 

Elaine,

The next version of Excel (out next year) will be able to do that.
Otherwise, VBA is required.
A commercial alternative, from yours truly, was reviewed by The Office Letter...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Elaine"
wrote in message...
Hello,
Is it possible to sort cells by fill colors without writing VBA? I'm using
Excel version 2003--
Thank you... Elaine

Sort by Fill Color
 

Hello again,

I tried your formula, =colorindex(a1) and got the #NAME? message. What did I
do wrong?
--
Thank you... Elaine


"Bob Phillips" wrote:

See http://xldynamic.com/source/xld.Colo...r.html#sorting

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Elaine" wrote in message
...
Hello,

Is it possible to sort cells by fill colors without writing VBA? I'm using
Excel version 2003
--
Thank you... Elaine

Sort by Fill Color
 

Did you add the UDF that was also supplied?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Elaine" wrote in message
...
Hello again,

I tried your formula, =colorindex(a1) and got the #NAME? message. What did
I
do wrong?
--
Thank you... Elaine


"Bob Phillips" wrote:

See http://xldynamic.com/source/xld.Colo...r.html#sorting

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Elaine" wrote in message
...
Hello,

Is it possible to sort cells by fill colors without writing VBA? I'm
using
Excel version 2003
--
Thank you... Elaine

Sort by Fill Color
 

Got it working. Read details from the website and it works like a champ!
--
Thank you .. Elaine


"Bob Phillips" wrote:

Did you add the UDF that was also supplied?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Elaine" wrote in message
...
Hello again,

I tried your formula, =colorindex(a1) and got the #NAME? message. What did
I
do wrong?
--
Thank you... Elaine


"Bob Phillips" wrote:

See http://xldynamic.com/source/xld.Colo...r.html#sorting

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Elaine" wrote in message
...
Hello,

Is it possible to sort cells by fill colors without writing VBA? I'm
using
Excel version 2003
--
Thank you... Elaine