Can you add the number of conditionally formatted cells??

  • Thread starter Thread starter Guest
  • Start date Start date
.. 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(A1>5,A1<8)

Then we could use this "similar-looking" formula in say, B1:
=SUMPRODUCT((A1:A10>5)*(A1:A10<8))
to provide the count of the number of cells triggered by the CF within the
range

---
Lost said:
Can you add the number of cells in a column or row? If so, how??
Click to expand...
Re: Can you add the number of conditionally formatted cells??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting 1
Conditional Formatting 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
If function using cell format as the condition 2
Excel Macro to automatically go to the right of the last colored cell 0
conditionally formatting 3
Conditional formatting a cell containing "<" 4
Comparison of columns using Conditional Formatting 3

Back
Top