"abielo" wrote:
.. How about a "color" function or something like that,
which will allow you to get the color of a particular cell?
Try Bob Phillips' page on "Processing Coloured Cells" at:
http://www.xldynamic.com/source/xld.....html#counting
Here's a sample file (~ "starter's kit") which
contains an implementation of Bob Phillips' ColorIndex
Function from his "Processing Coloured Cells" page (link above)
and some examples on how to use the UDF in Excel
(kit was given in response to a previous query)
Link to the sample file (construct details inside):
http://cjoint.com/?irheM1JmFp
CountSumCellsByColor_Using_BobPhillips_ColorIndex_ UDF.xls
An earlier link to the sample is still valid:
http://www.savefile.com/files/3232462
but think my archives' host: savefile.com is down at the moment
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 "Constraints" in
Bob's page. The sample should help you get started ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---