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)
"robnsd" wrote in message
oups.com...
Is there a way to count a cell if it has color shading? I have no
values in my cells, but they are either shaded a color or not. I only
want to count the cells that have color shading in the range I select.
Is this possible? I would rather not enter values or text in the cells
to count them.