Countif color

R

reddog_3d

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

thanks
 
G

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
 
Top