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.