Counting depending on kind of letters
 

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.

Counting depending on kind of letters
 

Visit www.cpearson.com.
Chip shows how to count by color etc.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"FC" wrote in message
...
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.

Counting depending on kind of letters
 

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.

"FC" wrote:

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.