Can you add the number of conditionally formatted cells??
 

Can you add the number of cells in a column or row? If so, how??

Can you add the number of conditionally formatted cells??
 

.. add the number of conditionally formatted cells??

Suppose we have applied CF to the range A1:A10
to trigger based on say:
Condition 1, Formula is: =AND(A15,A1<8)

Then we could use this "similar-looking" formula in say, B1:
=SUMPRODUCT((A1:A105)*(A1:A10<8))
to provide the count of the number of cells triggered by the CF within the
range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lost" wrote:
Can you add the number of cells in a column or row? If so, how??
Can you add the number of conditionally formatted cells??