Counting cells in Excel?

[Max]

So, I'm not sure how it went for you ?
... maybe I'll never know .. <bg>

 

[Peo Sjoblom]

I think he/she has posted again in a new thread

 

[Max]

I think he/she has posted again in a new thread

Thanks, Peo. Yes, so it seems. And s/he seems to be getting better at
specifying the questions ! <bg> cheers.

 

[Kelly Lim]

Hi Biff....regarding the formula that u taught me....do i need any VBA coding
to do so?
Pls reply asap..Thanks

 

[Kelly Lim]

Dear Biff, i have tried the formulas that u gave me...and finally it works
but counting the cells in red ( due date) and in orange ( 14 days within)

How bout i have other cells in other colour? like yellow, green, and cells
with no colour? are there any formula to do so which i can make it automatic
to count too? There contain no conditional formatting.....just manual fill in
colours...

Hope to hear from u real soon...
Thank You Biff....

 

[Max]

:
.....

How bout i have other cells in other colour?
like yellow, green, and cells
with no colour?
are there any formula to do so which i can
make it automatic to count too?
There contain no conditional formatting
.....just manual fill in colours...

For the above, you need to use a UDF (VBA), for example Bob Phillips'
ColorIndex UDF. Pl re-look the many responses given earlier in this thread /
branches: the link to Bob's page, the steps to implement Bob's UDF, a nice?
sample file with the implemented UDF to boot ... in all, a complete
"starter's kit" so as to speak. I've got practically nothing left to give
you but this response .. <bg>

 

[Kelly Lim]

Hi Max....

I 've tried all those url in this threads.....Regarding the
"KellyLim_CountingColoredCells_misc.xls" when i tried to update a colour in
the "Source Range" like changing red to orange.....and in the coloumns of
couting cells....still stays the same? How can i make it to auto update when
i have changes in the "Source Range" colours?
A huge thanks.....

 

[Max]

... How can i make it to auto update when

i have changes in the "Source Range" colours?

Think we need to add this line:
Application.Volatile
in the UDF itself
and then press F9 to recalc

Play with this revised sample file (link below)
which has the above implemented
and also includes a new "Reference Index" sheet
with the 56 default palette colors
(got this splash out with the help from the kind folks
over in excel.programming yesterday)

Calling Bob Phillips ... :
Would be grateful for your insights here ..
(Am I doing the correct things to your UDF, etc <g>)

Revised sample file:
http://flypicture.com/p.cfm?id=57100
(Right-click on the link: "Download File"
at the top in the page, just above the ads)
File: 2_KellyLim_misc.xls