trying to change a cells value to negative based on another cell input

I use Excel 2007
I am trying to change a cell(lets call it C2) to a negative of the number in the cell if another cell (lets call it L2) is changed to "picked up". If the quantity in C2 is already negative then leave it.

I have a sheet with an ongoing list of equipment coming, being pick up, or moved to another location. More like an event log for an inventory list. I have people forgeting to enter the quantity as a negative when something is picked up/Shipped and it then adds that amount back to the inventory.

I have set the sheet up to make the cell C2 red when L2 is set to picked up but people are going so fast and we are only human so they still forget.

You could use a worksheet change event:

Please Login or Register  to view this content.

Right click on the sheet tab, select view code and place the above on the resulting code sheet.

Dom

Try:

Please Login or Register  to view this content.

Dom

Here you go...

Please Login or Register  to view this content.

Dom