COUNTIF based on Format...
 

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

Thank you in advance.

COUNTIF based on Format...
 

see:

http://www.cpearson.com/excel/colors.htm


--
Gary''s Student
gsnu200710


"Steve" wrote:

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

Thank you in advance.

COUNTIF based on Format...
 

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


On Thu, 15 Mar 2007 17:51:11 -0700, Gary''s Student
wrote:

see:

http://www.cpearson.com/excel/colors.htm