On May 25, 9:00 pm, FSt1 wrote:
hi,
not sure what you are asking. I didn't say anything about formulas or dashes.

FSt1



"Roadmap" wrote:
On May 25, 8:17 pm, FSt1 wrote:
hi,
I think you may be right. color index 3 is red.
in vb help (alt+F11) look up the pattercolorindex property. it will show you
the delfaut colors and the corresponding index number. if you have custom
colors, then you must use the index number of the color you customized.

Regards
FSt1

"Roadmap" wrote:
I have a spreadsheet with 26 rows and 40 columns, some cells of which
have the background color of "tan". I need to count the colored cells
within each column. I've been going round and round with the vba
coding I found athttp://www.xldynamic.com/source/xld.ColourCounter.html
- I copied the code into the vbs window, saved the module and returned
to the worksheet. In the last row of the first column, I pasted this
function: =SUMPRODUCT(--(ColorIndex(A1:A26)=3))

I know this must be very simple, but I cannot get the module to work.
One reason may be that the color is not 3 - but tan.

Any suggestions?- Hide quoted text -

- Show quoted text -

Are the dashes within the formula to be included in the formula?- Hide quoted text -

- Show quoted text -

The dashes were in the formula I pasted from
http://www.xldynamic.com/source/xld.ColourCounter.html

This is what I pasted into the module: function: =SUMPRODUCT(--
(ColorIndex(A1:A26)=3))

The -- follow sumproduct(--