Count cells that are shaded?

[Guest]

I am looking for a way to count results of some testing. I can obviously use
"Countif" for my pass and fail results, but if I want to count my tests to
do, I am running into a problem.

My problem is that I cannot just use "CountBlank" because some cells I shade
because the row is informational data rather than results data and thus would
not be a valid "to do" test.

Question: Is there a way to take a range of cells and filter out those that
are not shaded?

Thanks in advance for any help or pointers.
-ec

 

[David McRitchie]

Hi Ed,
How is the shading accomplished, is it by Conditional Formatting.
If so than you would include that in your formula.

 

[Dave Peterson]

And if you've just applied a Format|Cells|pattern shade, you can use some macros
at Chip Pearson's site:

http://www.cpearson.com/excel/colors.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[David McRitchie]

you might also look at this posting by Harlan Grove
http://google.com/groups?threadm=#[email protected]

If you must check the color from manual shading see Chip Pearson's
http://www.cpearson.com/excel/colors.htm
for examples using Chip's functions, this might help
http://www.mvps.org/dmcritchie/excel/colors.htm#cpcolorsx
but it really is best to use builtin functions if possible rather than
User Defined Functions to check for colors after the you've manually
colored them yourself.

Hi Ed,
How is the shading accomplished, is it by Conditional Formatting.
If so than you would include that in your formula.
--
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

I am looking for a way to count results of some testing. I can obviously use
"Countif" for my pass and fail results, but if I want to count my tests to
do, I am running into a problem.

My problem is that I cannot just use "CountBlank" because some cells I shade
because the row is informational data rather than results data and thus would
not be a valid "to do" test.

Question: Is there a way to take a range of cells and filter out those that
are not shaded?

Thanks in advance for any help or pointers.
-ec

 

[Guest]

David,
Thanks for the reply. Unfortunately, no, it is not a Conditional Format.
The shading is just accomplished by Format | Cell... | Patterns | Color

In looking through the help I see what you are implying with the conditional
format, but I am unsure how to use that in my particular situation.

-ec

Hi Ed,
How is the shading accomplished, is it by Conditional Formatting.
If so than you would include that in your formula.
--
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

I am looking for a way to count results of some testing. I can obviously use
"Countif" for my pass and fail results, but if I want to count my tests to
do, I am running into a problem.

My problem is that I cannot just use "CountBlank" because some cells I shade
because the row is informational data rather than results data and thus would
not be a valid "to do" test.

Question: Is there a way to take a range of cells and filter out those that
are not shaded?

Thanks in advance for any help or pointers.
-ec

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html

--
Regards
Frank Kabel
Frankfurt, Germany

David,
Thanks for the reply. Unfortunately, no, it is not a Conditional Format.
The shading is just accomplished by Format | Cell... | Patterns | Color

In looking through the help I see what you are implying with the conditional
format, but I am unsure how to use that in my particular situation.

-ec

Hi Ed,
How is the shading accomplished, is it by Conditional Formatting.
If so than you would include that in your formula.
--
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

I am looking for a way to count results of some testing. I can obviously use
"Countif" for my pass and fail results, but if I want to count my tests to
do, I am running into a problem.

My problem is that I cannot just use "CountBlank" because some cells I shade
because the row is informational data rather than results data and thus would
not be a valid "to do" test.

Question: Is there a way to take a range of cells and filter out those that
are not shaded?

Thanks in advance for any help or pointers.
-ec