conditional formating?

[marcus]

I have this little problem:
I'm entering numbers in row B
A1 sums them
what do I have to do to sum the numbers in B1, only if they colored
red
but at the same time they have to be summed in A1
In other words all the numbers are summed in A1 but only red in B1
can anybody help me with this, please

Marcus

 

[Norman Jones]

Hi Marcus,

See xlDynamic at:

http://www.xldynamic.com/source/xld.ColourCounter.html

 

[marcus]

I have this little problem:
I'm entering numbers in row B
A1 sums them
what do I have to do to sum the numbers in B1, only if they colored
red
but at the same time they have to be summed in A1
In other words all the numbers are summed in A1 but only red in B1
can anybody help me with this, please

Marcus

Ooops, one more thing:
what do I do if I just want to count how many times red number shows
up in row 2 (not to add them up) and the result go to B1
(of course I meant row 2 not row B)

Marcus

 

[Norman Jones]

Hi Marcus,

See the previously suggested page which includes instructions for both
summing and counting by colour.

 

[marcus]

Hi Marcus,

See xlDynamic at:

http://www.xldynamic.com/source/xld.ColourCounter.html

Hmmm,
thanks for the link, but I'm kind of a beginner with Excel and this
got me a little confused on what I'm supposed to do
I guess I need a kind of step by step instructions and then try to
understand it with your help
Marcus

 

[marcus]

Hi Marcus,

See xlDynamic at:

http://www.xldynamic.com/source/xld.ColourCounter.html

first I thought it was the formula I have to use in B1, but it gives
me error (I think it does not recognize colourindex function) so I
scrolled down that page and see there is some vba code which gives me
trouble to understand or modify because I don't know vba at all
the way I understand it is:
vba code is there so when I enter the formula in certain cell
"colourindex" function will be recognizable by Excel
I tried to do it, but it does not work, maybe I would have to modify
the code somehow, but like I said, I'm afraid to touch it
Marcus

 

[Norman Jones]

Hi Marcus,

You need to copy the function to a standard code module:

Alt-F11 to open the VBE (Visual Basic Editor)
Insert | Module
Paste the code
Alt-F11 to return to Excel.

As you are new to VBA, you may wish to visit David McRitchie's 'Getting
Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm