Count how many times conditional formatted cells are positive

  • Thread starter Thread starter Caroline Keen
  • Start date Start date
C

Caroline Keen

Once you have applied conditional formatting, is it possible to count the
number of cells that turn the different colours?
 
Counting by colors requires code (a UDF). However, the simple workaround is
to count by the same condition that triggers the color.

If, for example, your condition is a positive number, then use:
=countif(range,">0")

Regards,
Fred
 

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 Removal 7
conditional formatting update issue 5
How to count cells that are highlighted by conditional formatting 1
Formula for Dates and CF Colour then convert to Text 3
Counting Colors of Cells set by Conditional Formatting 2
Count the number of colored cells in a column 5
Excel Named Ranges and Conditional Format 3
Conditional Formatting 3

Back
Top