Sort by Fill Color

[Elaine]

Hello,

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Jim Cone]

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" <[email protected]>
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

 

[Elaine]

Hello again,

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

 

[Bob Phillips]

Did you add the UDF that was also supplied?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Elaine]

Got it working. Read details from the website and it works like a champ!