how 2 Count number of cells that have specific condition format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Some time I need to count number of cells that have a cpecific conditional
format. Say how many cells have shade of certain color?

The cell might have some information or just balnk with the desiganted color
only.
 
The easiest way is to use a countif or sumproduct for the same condition as
the cf.
 
You need to replicate the conditional form at test. So, say the CF test
colours it red if cell value >10. Then you need to count the number of 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

Comparison of columns using Conditional Formatting 3
Counting Colors of Cells set by Conditional Formatting 2
count colored cells in excel 5
conditionally formatting 3
Excel Conditional Formatting 1
Count the number of colored cells in a column 5
Count Format Types 3
Conditional Format 4

Back
Top