software

I want to be able to count the number of cells that have coloured text from a
range of cells. Is their a way to do this, I tried quot;countifquot; but was unable
to get it working.

Thanks

See www.xldynamic.com/source/xld.ColourCounter.html for a solution.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Missilequot; gt; wrote in message
...
gt; I want to be able to count the number of cells that have coloured text
from a
gt; range of cells. Is their a way to do this, I tried quot;countifquot; but was
unable
gt; to get it working.
gt;
gt; Thanks
Thanks for the reply, unfortunatly when I try one of the solutions all I get
is an error. i don't know why but I am unable to get it to work. Even when I
tried to find the colorindex, that would not work.

quot;Bob Phillipsquot; wrote:

gt; See www.xldynamic.com/source/xld.ColourCounter.html for a solution.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Missilequot; gt; wrote in message
gt; ...
gt; gt; I want to be able to count the number of cells that have coloured text
gt; from a
gt; gt; range of cells. Is their a way to do this, I tried quot;countifquot; but was
gt; unable
gt; gt; to get it working.
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;

Before the formulae in the webpage will work you need to enter the VBA code
near the bottom of the webpage.
--
Gary''s Studentquot;Missilequot; wrote:

gt; Thanks for the reply, unfortunatly when I try one of the solutions all I get
gt; is an error. i don't know why but I am unable to get it to work. Even when I
gt; tried to find the colorindex, that would not work.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; See www.xldynamic.com/source/xld.ColourCounter.html for a solution.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Missilequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I want to be able to count the number of cells that have coloured text
gt; gt; from a
gt; gt; gt; range of cells. Is their a way to do this, I tried quot;countifquot; but was
gt; gt; unable
gt; gt; gt; to get it working.
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt;

Ahh ok, thanks, will give it ago

quot;Gary''s Studentquot; wrote:

gt; Before the formulae in the webpage will work you need to enter the VBA code
gt; near the bottom of the webpage.
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Missilequot; wrote:
gt;
gt; gt; Thanks for the reply, unfortunatly when I try one of the solutions all I get
gt; gt; is an error. i don't know why but I am unable to get it to work. Even when I
gt; gt; tried to find the colorindex, that would not work.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; See www.xldynamic.com/source/xld.ColourCounter.html for a solution.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Missilequot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I want to be able to count the number of cells that have coloured text
gt; gt; gt; from a
gt; gt; gt; gt; range of cells. Is their a way to do this, I tried quot;countifquot; but was
gt; gt; gt; unable
gt; gt; gt; gt; to get it working.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

Just spent the past hour or so looking at the VBA code and realised I have
absolutly no idea what it all means and how to apply anything I need. Looks
like I will just have to used old fashion pen and paper, lol

Thanks

quot;Missilequot; wrote:

gt; Ahh ok, thanks, will give it ago
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Before the formulae in the webpage will work you need to enter the VBA code
gt; gt; near the bottom of the webpage.
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; gt;
gt; gt; quot;Missilequot; wrote:
gt; gt;
gt; gt; gt; Thanks for the reply, unfortunatly when I try one of the solutions all I get
gt; gt; gt; is an error. i don't know why but I am unable to get it to work. Even when I
gt; gt; gt; tried to find the colorindex, that would not work.
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; See www.xldynamic.com/source/xld.ColourCounter.html for a solution.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Missilequot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; I want to be able to count the number of cells that have coloured text
gt; gt; gt; gt; from a
gt; gt; gt; gt; gt; range of cells. Is their a way to do this, I tried quot;countifquot; but was
gt; gt; gt; gt; unable
gt; gt; gt; gt; gt; to get it working.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;

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 ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Missilequot; gt; wrote in message
...
gt; Just spent the past hour or so looking at the VBA code and realised I have
gt; absolutly no idea what it all means and how to apply anything I need.
Looks
gt; like I will just have to used old fashion pen and paper, lol
gt;
gt; Thanks
Thanks all for you replies, low as my brain is I finally got it to work.
Only problem is, for it to work i have to save/close and reopen the file. It
dosent seem to update on the fly.

Missile

quot;Maxquot; wrote:

gt; Here's a recent* sample file (~ quot;starter's kitquot;) which contains an
gt; implementation of Bob Phillips' ColorIndex Function from his quot;Processing
gt; Coloured Cellsquot; page at:
gt; www.xldynamic.com/source/xld.ColourCounter.html
gt; and some examples on how to use the UDF in Excel
gt; *given in response to another query
gt;
gt; Link to the sample file (construct details inside):
gt; www.savefile.com/files/3348428
gt; CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls
gt;
gt; Hope the sample helps to get you started ..
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Missilequot; gt; wrote in message
gt; ...
gt; gt; Just spent the past hour or so looking at the VBA code and realised I have
gt; gt; absolutly no idea what it all means and how to apply anything I need.
gt; Looks
gt; gt; like I will just have to used old fashion pen and paper, lol
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;

toolsgt;optionsgt;calculation set to automatic, if you are using a UDF that is
non volatile press F9 to calculate

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Missilequot; gt; wrote in message
...
gt; Thanks all for you replies, low as my brain is I finally got it to work.
gt; Only problem is, for it to work i have to save/close and reopen the file.
gt; It
gt; dosent seem to update on the fly.
gt;
gt; Missile
gt;
gt; quot;Maxquot; wrote:
gt;
gt;gt; Here's a recent* sample file (~ quot;starter's kitquot;) which contains an
gt;gt; implementation of Bob Phillips' ColorIndex Function from his quot;Processing
gt;gt; Coloured Cellsquot; page at:
gt;gt; www.xldynamic.com/source/xld.ColourCounter.html
gt;gt; and some examples on how to use the UDF in Excel
gt;gt; *given in response to another query
gt;gt;
gt;gt; Link to the sample file (construct details inside):
gt;gt; www.savefile.com/files/3348428
gt;gt; CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls
gt;gt;
gt;gt; Hope the sample helps to get you started ..
gt;gt; --
gt;gt; Max
gt;gt; Singapore
gt;gt; savefile.com/projects/236895
gt;gt; xdemechanik
gt;gt; ---
gt;gt; quot;Missilequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Just spent the past hour or so looking at the VBA code and realised I
gt;gt; gt; have
gt;gt; gt; absolutly no idea what it all means and how to apply anything I need.
gt;gt; Looks
gt;gt; gt; like I will just have to used old fashion pen and paper, lol
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt;
gt;gt;
gt;gt;Thanks, Peo !

Missile: Yes, forcing recalc is one of 2 constraints highlighted by Bob
under the section quot;Constraintsquot; in his quot;Processing Coloured Cellsquot; page
(link provided earlier, part extract below). The other is that the UDF
(presently) does not count colours set by conditional formatting.

quot; .. The first shortcoming is that changing a cell's colour or the text
colour does not trigger the Excel calculate event. This is not a shortcoming
of the UDF, but of Excel's calculation event, but what this means is that
any formula that uses the Colorindex UDF to calculate a cell's colour will
not update should that cell's colour change. ... quot;
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---