Rather than counting color (which you can't do w/o
VB), count the cells
using same criteria as your conditional formats.
e.g.
=SUMPRODUCT(--(A2:A1000),--(A2:A100<=10))
Would count everything within A2:A100 that is greater than zero and less
than or equal to 10.
other example:
=SUMPRODUCT((A2:A100<0)+(A2:A10010))
Would count everything within A2:A100 that is less than 0 or greater than
10.
--
Best Regards,
Luke M
"lmiller" wrote in message
...
I have a spread sheet where if a number doesn't fall within certain limits
the font is red representing a NG part. If the number falls within
certain
limits the font is green representing a good part. I would like to know
if
there is a way to count the # of NG(or red numbers). I tried copying the
spreadsheet to my question but the fonts don't come over in color. There
are
numerous cells and would be much easier to count if there was a formula to
do
so. I know how to make a count formula but not one if the font is a
certain
color.