Error alert required if two amounts not matching!

[swaran_fca]

I have a balance sheet in USD in which there is a column for Assets and other column for Liabilities (both the totals should always be the same i.e. total of assets should be equal to total liabilities).

The amounts in Asset column and Liabilities column is linked to various different cells in various worksheets of the same file.

Now, if there is any change in any of the linked numbers, I get a difference in the balance sheet (i.e. the total assets does not equal total liabilities). For e.g. if I change an amount (which is linked to an amount in liabilities column) from USD 100 to USD 150, I get a difference of USD 50 in my balance sheet.

What I want is, as soon as the total of assets and liabilities do not match, I should get an error alert saying that total of assets and liabilities are not matching and have a difference of XXX amount.

Also, I want to set a limit up to which the difference would be alright/tolerable (say in my case, a difference of +5 or -5 should be fine). So, only if the difference is more than +5 or is less than -5 I should get an error alert.

Thanks for your help!

Do let me know if you need any further clarification.

 

[swaran_fca]

Just to elaborate, I am posting a link to an excel file which has an example.

http://linklemon.com/Erroralertondifference.xlsx

Thanks,
Swaran