Counting Color Cells

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Dec 10, 2003

• #2

This any use?

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

HTH

 

Upvote 0

D

danjw_98

Active Member

Joined

Oct 25, 2003

Messages

354

• Dec 10, 2003

• #3

I tried that also and it didn't work

 

Upvote 0

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Dec 11, 2003

• #4

Well I know for a fact that it does work so you've done something wrong...

 

Upvote 0

parry

MrExcel MVP

Joined

Aug 20, 2002

Messages

3,355

• Dec 11, 2003

• #5

danjw_98 said:

I tried to use the "=CountIfColor(a1:a10,3) to count the number of red filled cells and it doesn't seem to work - it shows "#name?" in the cell that I have this in.

any suggestions?

Click to expand...

What is the CountIfColor function - is it an add-in or your own UDF? Chip Pearsons site is really good and I agree with Iridium that it works just fine.

If you want a quick & dirty way to count the colours you can use this. Theres no error checking.

Code:

Sub CountColours()
Dim q1 As Range, q2 As Range, MyColour, c, I As Integer

Set q1 = Application.InputBox("Click on a cell that has the colour you want to count", _
"select Colour", , , , , , 8)

MyColour = q1.Interior.ColorIndex

Set q2 = Application.InputBox("Select the range to look in", _
"Range to count colour", , , , , , 8)

I = 0

For Each c In q2
If c.Interior.ColorIndex = MyColour Then
I = I + 1
End If
Next c

MsgBox "There are " & I & " cells in the range that match your colour"

End Sub

hth

 

Upvote 0

D

danjw_98

Active Member

Joined

Oct 25, 2003

Messages

354

• Dec 11, 2003

• #6

I entered the "countifcolor(a1:a10,3)" as a formula in cell a12 and i get the #name? in cell a12, I also tried "countbycolor(a1:a10,3)" with the same results. What am i doing wrong?

 

Upvote 0

texasalynn

Well-known Member

Joined

May 19, 2002

Messages

8,458

• Dec 11, 2003

• #7

There is not a function in Excel "COUNTIFCOLOR". The #NAME says that the formula name is not valid. What happened when you used the suggestion from Chip Pearson's site?

Please give us more info
texasalynn

 

Upvote 0