Counting Colored Cells

J

jvbelg

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!
 
J

jvbelg

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!
Click to expand...


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

KimC

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Address Format changed after Migration 0
Match table shading (color) to Visio color/Transparency 1
Changing row background from external program 0
conditional format - table - cell empty return default color 1
Number Of Cells Between Colored Cells? 1
Need help modifying code 0
Conditional Formatting with VBA 4
Remove Hyperlinks Without Changing background shading 14

Top