See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Murph" wrote in message
...
Can excel sum certain cells according to font color?

i.e. cash back expenses listed in red - summed to cell E4
credit card purchases listed in blue - sum to cell F4

the user manipulates the font color during input. But all values are
listed
in a Mon-Fri G1-K1 area