When paid turn cell green and change value

Hello,

In Excel 2007 I created a spread sheet to keep track of commissions on many jobs. When some of the job commissions are paid Iwant to be able to click on the cell in the Commissions column, have it turn green and turn the number to "0" and subtract from the total of commissions owed at the end of the column.

I am assuming I need to do it in MVB, but what is the code?

MANY thanks