It would have helped if you posted your Conditional Format (CF) formula. You
can use the CF formula in worksheet formula (without the leading equal sign,
of course) in order to count which cells met that condition or, as in your
case, not. For example, if your CF formula was this...

=MOD(A1:J400,3)=0)

then the worksheet formula to count the cells not shaded as a result of that
formula would be this...

=SUMPRODUCT((NOT(MOD(A1:J400,3)=0))*(A1:J400<""))

or, taking advantage of the Boolean nature of this particular expression, we
can change the logical test from = to < and remove the NOT function call...

=SUMPRODUCT((MOD(A1:J400,3)<0)*(A1:J400<""))

You will have to apply these ideas (and adjust the ranges) for your actual
situation (or post your CF formulas and data columns reference for us to
see).

--
Rick (MVP - Excel)


"Lisa L" <Lisa wrote in message
...
I have a worksheet in which i have used conditional formatting to gray out
certain values in a column. There are approximately 10 columns across all
with conditional formatting. Is anyone aware of a way to "count" the
number
of cells in each row that are not grayed out?