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