Formula to count colored cells?

[nacrelli]

In Excel 2007, is there a way to count the number of colored cells in a column? The cells are not automatically formatted with color, but instead are filled with color manually on an individual basis. There are different colors based on the appropriate situation for each cell. Thanks!

 

[VoG]

Try this http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

 

[nacrelli]

PERFECT! Thank you so much!!!

 

[Greg Truby]

FYI - Chip's got a ton of color-related stuff if you ever need more.

http://www.cpearson.com/excel/colors.aspx