Thread: Countif color
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Countif color

To count cells with bold text use this 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(A1:F23) or whatever range you choose.

Little more complex for colors.

See Chip Pearson's site for info and code.

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

One more method you may want to explore.

Select a range of cells and EditFindOptionsFormatFormatPattern. Select a
color and "Find All"

In the list box select top cell found then hold SHIFT key and select last cell
found.

You will get a count = xx on the Status bar if that option is set to "count"


Gord Dibben MS Excel MVP


On Fri, 16 Feb 2007 10:45:02 -0800, reddog_3d
wrote:

is there a way to get countif to count based on the color of text? how about
if text is bold?

thanks