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