| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Help based around countif and counta | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| countif based on fill color | Excel Worksheet Functions | |||
| Countif based on 2 criteria | Excel Worksheet Functions | |||
| Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Linear Mode
