Countif
 

Gene, have a look at chip's site here
http://www.cpearson.com/excel/colors.htm

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Gene" wrote in message
...
Any way to count a range using colors? (# in the range
that are light green, # in the range that are red, etc)