Countif color

[Guest]

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

thanks

 

[Bob Phillips]

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)

 

[Gord Dibben]

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 Edit>Find>Options>Format>Format>Pattern. 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