Count cells that are shaded?

E

Ed Campion

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
 
D

David McRitchie

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

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.
---
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

David McRitchie said:
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

Ed Campion said:
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
Click to expand...
Click to expand...
 
E

Ed Campion

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

David McRitchie said:
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

Ed Campion said:
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
Click to expand...
Click to expand...
 
F

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

Ed Campion said:
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

David McRitchie said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top