ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there a pull down Box to alert for minus balance such as ($5.00 (https://www.excelbanter.com/excel-worksheet-functions/53690-there-pull-down-box-alert-minus-balance-such-%245-00-a.html)

wildman

Is there a pull down Box to alert for minus balance such as ($5.00
 
In my spreadsheet I need to know when a negative balance such as ($5.00)
occurs.
I'am looking for a pull down box that will include text. This would be a
warning that the balance column doesn't contain enough dollars to cover the
checks written against this account.
When the error message pops up I would be alerted to add dollars in the
credit column or subtract dollars in the savings column. This would then show
a solvent account
Check No. Savings Debit Credit Balance
2358 $70.00 $50.00 $115.00 ($5.00)

Barb Reinhardt

Is there a pull down Box to alert for minus balance such as ($5.00
 
Why not use conditional formatting for this.
http://www.contextures.com/xlCondFormat02.html

"wildman" wrote in message
...
In my spreadsheet I need to know when a negative balance such as ($5.00)
occurs.
I'am looking for a pull down box that will include text. This would be a
warning that the balance column doesn't contain enough dollars to cover
the
checks written against this account.
When the error message pops up I would be alerted to add dollars in the
credit column or subtract dollars in the savings column. This would then
show
a solvent account
Check No. Savings Debit Credit Balance
2358 $70.00 $50.00 $115.00 ($5.00)





All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com