See
http://xldynamic.com/source/xld.ColourCounter.html
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"TJ" wrote in message
...
Hi
Is there a worksheet function, or combination of functions, that I can use
to count how may cells in a row have a background of red? E.g
=Countif(A2:A10, "Background = Red").
Thanks
TJ