summing columns

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm ashamed to say that although I passed City & Guilds a few years ago
I've forgotten almost everything I know about this program.

if I have a column of numbers say cells A1- 500, how can I put the
running total in B1, B2, etc?

Also, when there is a negative balance this comes up red, can I change
this to black?

Thanks

.