View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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.