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.

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.

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.

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.

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.