Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Missile" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
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 "Max" wrote: 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 .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Missile" wrote in message ... 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 |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
toolsoptionscalculation set to automatic, if you are using a UDF that is
non volatile press F9 to calculate -- Regards, Peo Sjoblom Portland, Oregon "Missile" wrote in message ... 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 "Max" wrote: 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 .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Missile" wrote in message ... 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 |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Cells
Thanks, Peo !
Missile: Yes, forcing recalc is one of 2 constraints highlighted by Bob under the section "Constraints" in his "Processing Coloured Cells" page (link provided earlier, part extract below). The other is that the UDF (presently) does not count colours set by conditional formatting. " .. 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. ... " -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells | Excel Discussion (Misc queries) | |||
Counting shaded cells | Excel Worksheet Functions | |||
Counting filled cells in excel | Excel Worksheet Functions | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel |