Hi

take a look at Bob Phillip's site for a solution
http://xldynamic.com/source/xld.ColourCounter.html

--
Regards

Roger Govier


"techiesol"
wrote in message
...

As subject, data are in different color font or cell. Can I sum the
data
by different color? e.g. add all the data in red font and/or in blue
cell.
Many thanks.


--
techiesol
------------------------------------------------------------------------
techiesol's Profile:
http://www.excelforum.com/member.php...o&userid=34728
View this thread:
http://www.excelforum.com/showthread...hreadid=544924