How do you count the number of colored cells

[channman]

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!

 

[Aladin Akyurek]

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]

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]

Re: Downloaded file

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.

 

[Norie]

Check this link Functions For Working With Cell Colors