| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count how many times conditional formatted cells are positive
Once you have applied conditional formatting, is it possible to count the
number of cells that turn the different colours? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count how many times conditional formatted cells are positive
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 "Caroline Keen" <Caroline wrote in message ... Once you have applied conditional formatting, is it possible to count the number of cells that turn the different colours? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to COUNT coloured in Conditional Formatted Cells | Excel Discussion (Misc queries) | |||
| Count if within conditional formatted cells | Excel Worksheet Functions | |||
| Count cells with positive numbers | Excel Discussion (Misc queries) | |||
| XL2003: Count formatted cells (not coloured)... | Excel Worksheet Functions | |||
| How do i count the number of conditional formatted cells? | Excel Discussion (Misc queries) | |||
Linear Mode
