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