View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default COUNT CELLS WITH CONDITIONAL FORMATTING

Don't count based on formatting. Count based on: "matching an input value."

But, we'd need the details!

--
Biff
Microsoft Excel MVP


"PEGWINN" wrote in message
...
Hi. I must have missed a function somewhere. I have a range of numbers
that
have conditional formatting based on matching an input value. What I would
like to do is count the cells that are conditionally formatted. I tried
the
count functions but cannot find an argument to identify formatting
differences. TIA -- Phil