Can you use the same criterion in a conditional formula?
For instance, if your CF is Formula is =A1>10
then you'd use
=COUNTIF(A:A,">10")
There's no direct way to count conditionally formatted cells.
In article <[email protected]>, "Jeff" <[email protected]>
wrote:
> Hi,
>
> Is it possible to count the number of cells (most often in a filtered) range
> that are "activated" by meeting the condional formatting formula?
> In my case, I'm using colours to indicate the number of rows that meet the
> criteria. I know the number of rows in the filtered range n (thanks to this
> forum). I find in my analysis, I am always manually counting the incidence
> of meeting criteria and express the quantity as a percentage of n and
> wondered if this can be achieved programatically.
>
> I only need to count the incidence and have the skills to do the rest of my
> task objective.
> regards
> Jeff
Bookmarks