Count Formats

M

Matt

Can you use a count function to count the number of cells with a particular
format, say a colour?
 
D

dominicb

Good morning Matt

There is no native function to do this. I have an add-in available t
anyone who requests it that will count or sum the number of cells wit
fonts or backgrounds that are a particular colour, but it will no
interrogate based on any other format (bold, underline, centred etc.

HTH

DominicB
[email protected]
 
J

Jack Sons

Matt,

During the years I gathered a lot of handy code. I once found these macro's.
Just what you need.

Jack Sons
The Netherlands
----------------------------------------------------------------------------------------------------
Sub SumColorCountYellow()
Dim Yellow6 As Integer
Dim Cell As Range

For Each Cell In Range("DataY")
If Cell.Interior.ColorIndex = 6 Then
Yellow6 = Yellow6 + Cell.Value
End If
Next
originalF = Range("F1").Value
Range("F1").Value = "Yellow = " & Yellow6

MsgBox " Yellow adds to " & Yellow6, _
vbOKOnly, "CountColor"

Range("F1").Value = originalF '""
End Sub
---------------------------------------------------------------------------------------------
Function BoldSum(rng)
' sommeert de vette cellen in de range
Dim c
For Each c In rng
If c.Font.Bold Then
BoldSum = BoldSum + c.Value
End If
Next

End Function
 
Top