auto calculating macro

[isaacko]

Dear guys,

i need your help tosolve my problem. hope you'll understand my problems

i have a table that consist of some transactions. what i want to ask is :
1. if to input S (Sell) in the column C, and the color in the "unit" and "total" will change into red (same line)
2. i'm using standard excel formula to find the result (historical price). is there any formula/macro to automatically calculate the total everytime i input the new transaction?
I attached the sample of my workbook. im sorry if my english wasn't good enough. thank you in advance if anyone can solve my problem.

File : Sample.xlsx

[Kaper]

1. Use conditional formating. The rule based on formula:

Please Login or Register  to view this content.

2. in C8 formula:

Please Login or Register  to view this content.

and similar in C9.