software

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--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=504284See 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

quot;darkbearpooh1quot;
gt;
wrote in message
news:darkbearpooh1.224e4y_1138074302.0157@excelfor um-nospam.com...
gt;
gt; hi can anyone help me get a cell to count the number of other
gt; cells just
gt; colored a specific color?
gt;
gt; looked at other post came up with something like
gt; =COUNTBYCOLOR(A1:A10,3,FALSE)
gt; but can not get it to work
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=504284
gt;
Just another option to try ..

Here's a recent* sample file (~ quot;starter's kitquot;) which contains an
implementation of Bob Phillips' ColorIndex Function from his quot;Processing
Coloured Cellsquot; page at:
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):
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
quot;Constraintsquot; in Bob's page.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;darkbearpooh1quot; gt;
wrote in message
news:darkbearpooh1.224e4y_1138074302.0157@excelfor um-nospam.com...
gt;
gt; hi can anyone help me get a cell to count the number of other cells just
gt; colored a specific color?
gt;
gt; looked at other post came up with something like
gt; =COUNTBYCOLOR(A1:A10,3,FALSE)
gt; but can not get it to work
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=504284
gt;

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--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=504284There's a link to a sample file (~ a quot;starter's kitquot;) 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 lt;ggt; ?
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;darkbearpooh1quot; gt;
wrote in message
news:darkbearpooh1.224fam_1138075803.6956@excelfor um-nospam.com...
gt;
gt; thanks i have this webpage saved as reference but i don't understand i
gt; am sorry, does that mean i have to load something in order to be able
gt; to use that function and if so how do i go about doing that
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=504284
gt;