How can I count the number of cells that have conditional formats?

[Guest]

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.

 

[Guest]

Yes, you can...

post your condiditional formatting formula and someone will come up with the
answere

 

[Guest]

sumproduct() works fairly well for this type of operation.

 

[Guest]

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).

 

[Gord Dibben]

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