How do you count the number of colored cells

channman

New Member
Joined
Dec 8, 2005
Messages
2
I would like to count the number of colored cells in a range.
Does anyone know how to do this. I thought this would work
=COUNTIF(C13:AA36,"*Cell.Color[1}}*") but I think I need
more info. I do not want to count the number in the cell just
the number of instances that the cell in a certain color.
Please Help!
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
channman said:
I would like to count the number of colored cells in a range.
Does anyone know how to do this. I thought this would work
=COUNTIF(C13:AA36,"*Cell.Color[1}}*") but I think I need
more info. I do not want to count the number in the cell just
the number of instances that the cell in a certain color.
Please Help!

One way...

Download and install the morefunc.xll add-in and study the example the system provides using XLM.GET.CELL combined with SumProduct.
 

channman

New Member
Joined
Dec 8, 2005
Messages
2
Downloaded file

I downloaded the file but it seems to be corupt. The zip only contains a
setup.exe and will not run.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Re: Downloaded file

channman said:
I downloaded the file but it seems to be corupt. The zip only contains a
setup.exe and will not run.

Download a fresh copy and re-try.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,706
Members
412,481
Latest member
nhantam
Top