![]() |
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) |
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