| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count the number of cells that have conditional formats?
I have a spreadsheet with lots of conditional formatting.
I want to be able to count (per row) the number of cells that have conditional formatting (e.g. 6 out of 20 cells have met the conditions and font/pattern has been formatted) - can I use some sort of countif or something? I am using Excel 2003. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I count the number of cells that have conditional formats?
Yes, you can...
post your condiditional formatting formula and someone will come up with the answere "Annelies" wrote: I have a spreadsheet with lots of conditional formatting. I want to be able to count (per row) the number of cells that have conditional formatting (e.g. 6 out of 20 cells have met the conditions and font/pattern has been formatted) - can I use some sort of countif or something? I am using Excel 2003. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I count the number of cells that have conditional formats?
sumproduct() works fairly well for this type of operation.
"Annelies" wrote: I have a spreadsheet with lots of conditional formatting. I want to be able to count (per row) the number of cells that have conditional formatting (e.g. 6 out of 20 cells have met the conditions and font/pattern has been formatted) - can I use some sort of countif or something? I am using Excel 2003. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I count the number of cells that have conditional form
if the cells meet this condition: =VLOOKUP(B3;$N$56:$N$97;1;FALSE) font is changed to white and pattern to blue Per row there are 10 cells; I want to count (per row) the number of cells where the condition is met (the number of blue-white cells). "Teethless mama" wrote: Yes, you can... post your condiditional formatting formula and someone will come up with the answere "Annelies" wrote: I have a spreadsheet with lots of conditional formatting. I want to be able to count (per row) the number of cells that have conditional formatting (e.g. 6 out of 20 cells have met the conditions and font/pattern has been formatted) - can I use some sort of countif or something? I am using Excel 2003. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I count the number of cells that have conditional form
You could use VBA code for determining and counting conditions that have been
met. Chip Pearson has several Functions at his site. Browse through to find something that do the job. http://www.cpearson.com/excel/CFColors.htm Gord Dibben MS Excel MVP On Mon, 19 Mar 2007 13:01:16 -0700, Annelies wrote: if the cells meet this condition: =VLOOKUP(B3;$N$56:$N$97;1;FALSE) font is changed to white and pattern to blue Per row there are 10 cells; I want to count (per row) the number of cells where the condition is met (the number of blue-white cells). "Teethless mama" wrote: Yes, you can... post your condiditional formatting formula and someone will come up with the answere "Annelies" wrote: I have a spreadsheet with lots of conditional formatting. I want to be able to count (per row) the number of cells that have conditional formatting (e.g. 6 out of 20 cells have met the conditions and font/pattern has been formatted) - can I use some sort of countif or something? I am using Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the best way to count conditional formats? | Excel Discussion (Misc queries) | |||
| Number of Conditional Formats | Excel Worksheet Functions | |||
| How do i count the number of conditional formatted cells? | Excel Discussion (Misc queries) | |||
| How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
| Conditional Number Formats | Excel Discussion (Misc queries) | |||
Linear Mode
