add cells value base on word's color

[patlee311]

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.

 

[Bob Phillips]

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)