counting cell color help

[darkbearpooh1]

hi can anyone help me get a cell to count the number of other cells just
colored a specific color?

looked at other post came up with something like
=COUNTBYCOLOR(A1:A10,3,FALSE)
but can not get it to work

 

[Chip Pearson]

See www.cpearson.com/excel/colors.htm for a sample VBA function
to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"darkbearpooh1"
<[email protected]>
wrote in message
news:[email protected]...

 

[Max]

Just another option to try ..

Here's a recent* sample file (~ "starter's kit") which contains an
implementation of Bob Phillips' ColorIndex Function from his "Processing
Coloured Cells" page at:
http://www.xldynamic.com/source/xld.ColourCounter.html
and some examples on how to use the UDF in Excel
*given in response to another query

Link to the sample file (construct details inside):
http://www.savefile.com/files/3348428
CountCellsByFillColor_Using_BobPhillips_ColorIndex_UDF.xls

Hope the sample helps to get you started ..

Note that as the UDF is non volatile, recalc has to be forced, even if calc
mode is set to Automatic. Press F9 to force recalc. Read the section
"Constraints" in Bob's page.

 

[darkbearpooh1]

thanks i have this webpage saved as reference but i don't understand i
am sorry, does that mean i have to load something in order to be able
to use that function and if so how do i go about doing that

 

[Max]

There's a link to a sample file (~ a "starter's kit") in my response to you
y'day, which would ease you in (it contains an implementation of Bob's
ColorIndex UDF). Full details, including steps on how to implement the UDF
are provided in the sample. Why not check it out while awaiting Chip's
response <g> ?