Counting conditional formatting

[Guest]

Re my earlier post, I am tring to fond a formula to count those cells that
have been formatted by conditional formatting.

 

[Ron Rosenfeld]

Re my earlier post, I am tring to fond a formula to count those cells that
have been formatted by conditional formatting.

I have no idea what your earlier post was, as this post appears in a thread by
itself.

But to count those cells that have been formatted by conditional formatting,
you will need to use the same formula that you used for the conditional format.

For example, if you formatted cells to turn red if their value equals one,
then:

=COUNTIF(rng,1)


--ron

 

[kkknie]

It's not possible (for some god-unknown reason) to do this. The onl
way to do it is to check for what formula was used to create th
conditional formatting. If you try to check the Interior.ColorIndex o
the cell it will return the normal value (i.e. the value if th
formatting didn't take place).

This is the main reason I don't use it...

Sorry,

 

[Dave Peterson]

You have one more reply at your initial post.

Re my earlier post, I am tring to fond a formula to count those cells that
have been formatted by conditional formatting.

 

[Bob Phillips]

I think it is possible, not easy, but possible.

 

[David McRitchie]

Where is that other post (author, subject, newsgroup).

It certainly would not be worth the effort of obtaining
the three C.F. possible per cell an evaluating each of them.

You can use this for a test.
Select all cells on the sheet (A1 as activecell)
and use this for the Conditional Formatting formula.
=ISBLANK($A13)
Sprinkle in a some content into some of the cells in column A.

Considering that it would take about 3 minutes per column
just to do a simply comparison on my computer for each cell.
I would take a lot more time and effort to obtain the conditional formats
and evaluate each to find out if True or False.

An example with just one Conditional Formatting formula would
take a long time by checking every cell. But if you used a
program or in this case a Worksheet Solution to calculate
what is actually being checked and how it affects the rest
could be as simple as:
=(35536 - COUNTA(A:A))*256

 

[Debra Dalgleish]

Same author and newsgroup, subject: counting autoformatted cells

http://groups.google.com/groups?&[email protected]

Where is that other post (author, subject, newsgroup).

It certainly would not be worth the effort of obtaining
the three C.F. possible per cell an evaluating each of them.

You can use this for a test.
Select all cells on the sheet (A1 as activecell)
and use this for the Conditional Formatting formula.
=ISBLANK($A13)
Sprinkle in a some content into some of the cells in column A.

Considering that it would take about 3 minutes per column
just to do a simply comparison on my computer for each cell.
I would take a lot more time and effort to obtain the conditional formats
and evaluate each to find out if True or False.

An example with just one Conditional Formatting formula would
take a long time by checking every cell. But if you used a
program or in this case a Worksheet Solution to calculate
what is actually being checked and how it affects the rest
could be as simple as:
=(35536 - COUNTA(A:A))*256

 

[Dave Peterson]

You can find the other thread at:
http://groups.google.com/[email protected]