Count Formula

G

Guest

Is there a formula that will allow you to count the number of cells that have
conditional formatting applied to them?
 
D

Dave Peterson

Nothing built into excel.

But this may be sufficient.
Select your range
Edit|goto|special
check Conditional formats

rightclick on the status bar on the bottom right (near the "embossed" boxes).
Choose count.

This will fail if there's only one cell with conditional formatting in that
range.

or

if the cells with the conditional formatting are empty.
 

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

Count how many times conditional formatted cells are positive 1
count colored cells in excel 5
Count the number of colored cells in a column 5
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
Count for specific format? 8
Conditional Cell Formatting 5
Conditional Formatting 3
Counting Colors of Cells set by Conditional Formatting 2

Top