P
Peter
Re my earlier post, I am tring to fond a formula to count those cells that
have been formatted by conditional formatting.
have been formatted by conditional formatting.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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
K
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,
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,
D
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.
B
Bob Phillips
I think it is possible, not easy, but possible.
D
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
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
D
Debra Dalgleish
Same author and newsgroup, subject: counting autoformatted cells
http://groups.google.com/groups?&[email protected]
http://groups.google.com/groups?&[email protected]
David said: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
D
Dave Peterson
You can find the other thread at:
http://groups.google.com/[email protected]
http://groups.google.com/[email protected]
David said: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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Dave Peterson said:You have one more reply at your initial post.