Counting the number of cells meeting conditional formating criteria

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

Thanks for this. Does this mean I will have to create a column for a
true/false to criteria and count them in the filtered range? The real value
of this forum is people come up with some solutions that the Excel sites say
can't be done (like counting the number of filtered rows). I marvel at the
skills and expertise of you contributors.


"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> 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

Not necessarily - the example I gave could be done in one cell. What is
your conditional?


In article <[email protected]>, "Jeff" <[email protected]>
wrote:

> Thanks for this. Does this mean I will have to create a column for a
> true/false to criteria and count them in the filtered range?

I apologise for not getting back. I solved the problem (thanks) and forgot
I'd asked that query :- (
sincerely

Jeff


"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> Not necessarily - the example I gave could be done in one cell. What is
> your conditional?
>
>
> In article <[email protected]>, "Jeff" <[email protected]>
> wrote:
>
>> Thanks for this. Does this mean I will have to create a column for a
>> true/false to criteria and count them in the filtered range?

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

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

Thanks for this. Does this mean I will have to create a column for a
true/false to criteria and count them in the filtered range? The real value
of this forum is people come up with some solutions that the Excel sites say
can't be done (like counting the number of filtered rows). I marvel at the
skills and expertise of you contributors.


"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> 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

Not necessarily - the example I gave could be done in one cell. What is
your conditional?


In article <[email protected]>, "Jeff" <[email protected]>
wrote:

> Thanks for this. Does this mean I will have to create a column for a
> true/false to criteria and count them in the filtered range?

I apologise for not getting back. I solved the problem (thanks) and forgot
I'd asked that query :- (
sincerely

Jeff


"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> Not necessarily - the example I gave could be done in one cell. What is
> your conditional?
>
>
> In article <[email protected]>, "Jeff" <[email protected]>
> wrote:
>
>> Thanks for this. Does this mean I will have to create a column for a
>> true/false to criteria and count them in the filtered range?