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

thanks

See http://xldynamic.com/source/xld.ColourCounter.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"reddog_3d" wrote in message
...
is there a way to get countif to count based on the color of text? how
about
if text is bold?

thanks

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