See if this doesn't get you started:
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
"Atomic" wrote:
I'd like to know how we can count coloured cells?
i.e
If cells A1 C1 E1 F1 and G1 are coloured, Id like to know how I can see the
total coloured cells in H1?
I suppose its a little bit more complicated than it looks. Any help would
be appreciated. Thank you.