Counting depending on kind of letters

F

FC

Can somebody provide me with a FORMULA, CONDITIONAL FORMATTING or a
way to count in a column, let's say, how many CELLS are written in specific
kind of letters? ( ex. arial, britanic bold, etc.).Thanks in advance.
 
J

JLatham

To add to what Bernard said, the property you'd need to test for (instead of
Interior.ColorIndex) would be the cell's .Font.Name property, like:
If ActiveCell.Font.Name = "Times New Roman" Then
' add 1 to counter
End IF

Hope this helps you change examples you find to suit your need.
 
Top