COOL!, that works... Thanks!
"Bob Phillips" wrote:
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)
"Kevin" wrote in message
...
I have a simple formula...
=SUM(C61:AY61)
The cells represent open slots in a fiber switch. some of the cells are
colored gray to represent no hardware installed for that slot. is there a
way
to have the formula only add the cells that are not gray? I didnt see any
color options in conditioanl formatting.
Thanks