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