counting colored data
Are the coloprs the result of Conditional Formatting?
Count based on those conditions.
Gord Dibben MS Excel MVP
On Thu, 1 Apr 2010 07:45:02 -0700, 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.
|