See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
...
Dear all,
can I add cells value base the color of the word's color.
e.g. if word color=red then sum(a1:a10).

Thanks,
Pat.