See
http://www.xldynamic.com/source/xld.ColourCounter.html
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"MSOChick" wrote in message
...
Hello,
I am trying to ceate a SUM formula to add only the green filled
cells in a specified range. I am trying to do it with sum and
cell("color",reference) but I can't seem to be able to find color values.
A
formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any
help
would be appreciated.
Thanks,
Lia