COUNTIF based on Format...

S

Steve

What is the formula for counting how many BOLD cells are located in a row or
worksheet?

Thank you in advance.
 
G

Gord Dibben

Or a UDF

Function CountBold(rg As Range) As Long
''originally posted by Ron Rosenfeld
Dim c As Range
For Each c In rg
CountBold = CountBold - c.Font.Bold
Next c
End Function

usage is: =CountBold(range)


Gord Dibben MS Excel MVP
 
Top