When paid turn cell green and change value

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
depends upon configuration of data sheet