Hi,

I still think this can be done with a formula but you didn't give us all the
number ranges.

If you want to count conditional format colours then it can be done but it
isn't easy. Bob Philips has a solution here

http://www.xldynamic.com/source/xld.CFConditions.html

If you don't fancy this route then post the number limits for each row and
someone will work out a solution.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"lmiller" wrote:

Thanks Mike,

Each cell has a conditional format. I posted an excert from my worksheet
but unfortunatly the data didn't come over color coded for you to see. For
sake of argument let say the first column is red and the remaining colums are
green. Each cell has a conditional format. If the # doesn't falls between
certain limits it prints in red. If it does fall between certain number it
prints in green. Instead of manually counting all the red numbers, I
wanted to try and do a count based on my conditional format. Each row has
it's own limits and the worksheet contains about 100 rows but I need an
overall "red" count. It's quite cumbersome to manually count and I thought
the formual would be extremely long.

0.180 0.184 0.113 0.111
0.173 0.177 0.113 0.119
0.846 0.751 0.075 0.050


"Mike H" wrote:

Hi,

You can't count the colours with a worksheet function but you can get the
count you want by directly checking the numbers. tell us the number limits
and someone will help
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"lmiller" wrote:

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.