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.

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.

Hi,

Excel has no inbuilt functions for this but here's a user defined function
(UDF)

Alt + f11 to open VB editor and right click 'ThisWorkbook' and insert nodule
and paste the code below in.

Call with
=countcolour("A1:H1")

or any other range you want

Function countcolour(rng As Range) As Long
For Each c In rng
If c.Interior.ColorIndex < xlNone Then
countcolour = countcolour + 1
End If
Next
End Function

Mike

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

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.