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!

On Mar 9, 10:41*am, jvbelg <jvrom...@gmail.com> 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.

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 <jvrom...@gmail.com> 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.
>