I'd like to know how we can count coloured cells?
If they are coloured by conditional formatting, use those conditions to
count the cells.
If the cells are formatted separately, you can't do it with a formula; it
needs VBA.
--
David Biddulph
"Atomic" wrote in message
...
I'd like to know how we can count coloured cells?
i.e
If cells A1 C1 E1 F1 and G1 are coloured, I'd like to know how I can see
the
total coloured cells in H1?
I suppose it's a little bit more complicated than it looks. Any help would
be appreciated. Thank you.
|