| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how 2 Count number of cells that have specific condition format?
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. |
|
#2
|
|||
|
|||
|
The easiest way is to use a countif or sumproduct for the same condition as
the cf. -- Don Guillett SalesAid Software "daveydavey" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
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 10. -- HTH Bob Phillips "daveydavey" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for counting specific cells with value greater than 0 | Excel Discussion (Misc queries) | |||
| Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) | |||
| How do I count the number of cells in a column in excel that begi. | Excel Discussion (Misc queries) | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| how do I find an average number of specific words in a column | New Users to Excel | |||
Hybrid Mode
