| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting conditionally formatted cells
Hi,
I am looking for a formula that allows me to count the cells in a range that have been conditionally formatted. By this I mean only those cells that have satisfied their respective conditions and therefore have had the special formatting applied. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting conditionally formatted cells
Hi,
Take a look at Bob's brilliant site : http://www.xldynamic.com/source/xld.CFConditions.html HTH Carim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting conditionally formatted cells
The simplest way is to sum using the same tests as the CF.
If you want another solution, look at http://www.xldynamic.com/source/xld.CFConditions.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kebbon" wrote in message ... Hi, I am looking for a formula that allows me to count the cells in a range that have been conditionally formatted. By this I mean only those cells that have satisfied their respective conditions and therefore have had the special formatting applied. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Counting colour formatted cells | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Hybrid Mode
