Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting letters. | Excel Worksheet Functions | |||
Counting cell depending on certain crieteria | Excel Discussion (Misc queries) | |||
counting rows depending on 2 selective values | Excel Discussion (Misc queries) | |||
Counting Letters | Excel Worksheet Functions | |||
Counting Letters | Excel Worksheet Functions |