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)
"Arnie" wrote in message
...
i have looked around the answers for this but cant seem to get any to work.
i
am looking for a formula to look in A1:A160 and count the cells if they
are
blue or Red the text in them is irrelivant
Thanks in advance