Counting Colored Cells
 

Is there a way in Excel 2007 to count how many cells in a worksheet
are formatted with a particular standard color value?
Does the answer change if the color formatting is based on Conditional
Formatting?
Thanks!

Counting Colored Cells
 

On Mar 9, 10:41*am, jvbelg wrote:
Is there a way in Excel 2007 to count how many cells in a worksheet
are formatted with a particular standard color value?
Does the answer change if the color formatting is based on Conditional
Formatting?
Thanks!


Never mind! -- Both ozgrid and Chip Pearson have extended explanations
of how to achieve the above.

Counting Colored Cells
 

I have downloaded the code referred to in this post to count cells of a
particular font color. I am not getting the correct count in my columns.
How does thid code handle blank cells in the column. Also, is there a way to
compare a font color used in a sheet to the Color Index list to see exactly
what color it is?

"jvbelg" wrote:

On Mar 9, 10:41 am, jvbelg wrote:
Is there a way in Excel 2007 to count how many cells in a worksheet
are formatted with a particular standard color value?
Does the answer change if the color formatting is based on Conditional
Formatting?
Thanks!


Never mind! -- Both ozgrid and Chip Pearson have extended explanations
of how to achieve the above.