Is there any way (with or without code) to count the number of cells that
have a condition that displays a specific colorindex tied to a conditional
format?

Thanks,

Barb Reinhardt

Barb,

I answered no to this once and Bob Philips corrected me and pointed me
towards his page below. You can count conditionally formatted cells but it
ain't easy.

http://www.xldynamic.com/source/xld.CFConditions.html
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Barb Reinhardt" wrote:

Is there any way (with or without code) to count the number of cells that
have a condition that displays a specific colorindex tied to a conditional
format?

Thanks,

Barb Reinhardt

Are we talking about the same Conditional Format formula for the color... or
could there be different Conditional Format formulas that display the same
color? Also, is there only going to be one conditional test per cell... or
could the cell have multiple test? Also, are we talking about counting cells
with that currently displaying the color as a result of the conditional test
being TRUE... or just cells with a conditional test that **could** produce
the color if the test evaluates to TRUE, whether it is TRUE now or not?

--
Rick (MVP - Excel)



"Barb Reinhardt" wrote in message
...
Is there any way (with or without code) to count the number of cells that
have a condition that displays a specific colorindex tied to a conditional
format?

Thanks,

Barb Reinhardt

I'll echo what Rick said. You may, or may not, be able to do it. Try this:
http://www.cpearson.com/Excel/CFColors.htm

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rick Rothstein" wrote:

Are we talking about the same Conditional Format formula for the color... or
could there be different Conditional Format formulas that display the same
color? Also, is there only going to be one conditional test per cell... or
could the cell have multiple test? Also, are we talking about counting cells
with that currently displaying the color as a result of the conditional test
being TRUE... or just cells with a conditional test that **could** produce
the color if the test evaluates to TRUE, whether it is TRUE now or not?

--
Rick (MVP - Excel)



"Barb Reinhardt" wrote in message
...
Is there any way (with or without code) to count the number of cells that
have a condition that displays a specific colorindex tied to a conditional
format?

Thanks,

Barb Reinhardt

.

Use the same condition as you CF condition in a formula.



--
Regards
Dave Hawley
www.ozgrid.com
"ryguy7272" wrote in message
...
I'll echo what Rick said. You may, or may not, be able to do it. Try
this:
http://www.cpearson.com/Excel/CFColors.htm

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rick Rothstein" wrote:

Are we talking about the same Conditional Format formula for the color...
or
could there be different Conditional Format formulas that display the
same
color? Also, is there only going to be one conditional test per cell...
or
could the cell have multiple test? Also, are we talking about counting
cells
with that currently displaying the color as a result of the conditional
test
being TRUE... or just cells with a conditional test that **could**
produce
the color if the test evaluates to TRUE, whether it is TRUE now or not?

--
Rick (MVP - Excel)



"Barb Reinhardt" wrote in
message
...
Is there any way (with or without code) to count the number of cells
that
have a condition that displays a specific colorindex tied to a
conditional
format?

Thanks,

Barb Reinhardt

.