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 |