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 "countif" but was unable
to get it working.

Thanks

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Missile" wrote in message
...
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 "countif" but was
unable
to get it working.

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.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Missile" wrote in message
...
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 "countif" but was
unable
to get it working.

Thanks

Before the formulae in the webpage will work you need to enter the VBA code
near the bottom of the webpage.
--
Gary''s Student


"Missile" wrote:

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.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Missile" wrote in message
...
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 "countif" but was
unable
to get it working.

Thanks

Ahh ok, thanks, will give it ago

"Gary''s Student" wrote:

Before the formulae in the webpage will work you need to enter the VBA code
near the bottom of the webpage.
--
Gary''s Student


"Missile" wrote:

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.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Missile" wrote in message
...
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 "countif" but was
unable
to get it working.

Thanks

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

"Missile" wrote:

Ahh ok, thanks, will give it ago

"Gary''s Student" wrote:

Before the formulae in the webpage will work you need to enter the VBA code
near the bottom of the webpage.
--
Gary''s Student


"Missile" wrote:

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.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Missile" wrote in message
...
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 "countif" but was
unable
to get it working.

Thanks