Triggering an action when an item is selected from a dropdown menu

[Xonnel1212]

Hello,

I am constructing a general ledger in excel 2007 and I would like to create
a drop down list that will trigger an action in another cell.

I have created a drop down menu in a table column with the heading "status."
The menu includes a selection for "cleared" and "not cleared" items. My goal
is to click an option and have a specific action occur.

If I click on "cleared" I would like the amount that has been entered in the
corresponding row and column entitled "amount paid" to be subtracted from the
columns entitled "current account balance" and "running balance."

If I switch it to "not cleared" I would like the amount in the corresponding
row and column entitled "amount paid" to be subtracted from the column
entitled "running balance" only.

I only have basic knowledge of excel and so I need to know if this can be
done, and if so, step by step instructions on how to do it. I wish I could
have added a picture to make my question more clear but hopefully someone
will be able to respond.

Thank you in advance!

 

[Shane Devenshire]

I think you can do this with formulas, something like this:

=IF(A1="Cleared",F1-D1,"")
=IF(A1="Not Cleared",E1-D1,If(A1="Cleared",F1-D1))