excel VBA

[[NB]Zaibatsu]

hello maybe someone can help me solve some questions about VBA in excel:



so

what do i need to type to VBA when i need:

1.if i enter a positive number into yellow area, the box will change to blue (the same box where i typed the number)
2.if i enter a negative number into yellow area, the box will change to red
3.if i type any number on any other location (not in yellow area), nothing will happen
4.to have the sum of the positive numbers into the blue box in top
5.to have the sum of the negative numbers into the red box in top

thanks in advance )))))))))))))))

[IDmad]

do ur own homework u noob! 

[[NB]Zaibatsu]

tryin but ure not doing it for me 

[thiaZ]

I'm not sure if that or that may help you, but I hope so. You would basically have to check for the value in the cell, if it is < 0 make it red (RGB -> 255, 0, 0), otherwise make it blue (RGB -> 0, 0, 255), I never worked with VBA in Excel, so you would have to do that on your own, except someone else here could help you.

[Gaahl]

http://neddyy.net/docs/

Hitman gave me the link to this page, awesome shit dude.

[XiZ]

http://neddyy.net/docs/

Hitman gave me the link to this page, awesome shit dude.

That german faggot knows his cheater shit. Still, it did me good once.

[Blackbean]

http://neddyy.net/docs/

Hitman gave me the link to this page, awesome shit dude.

Thanks for the link. will be using it alot.

[[NB]Zaibatsu]

still open for suggestions