if the cell value exceeds the limit to have a dialog box appear
Is there a way that, if the cell value exceeds a certain limit, a dialog box
would appear? Thanks for any assistance. Dave |
if the cell value exceeds the limit to have a dialog box appear
Check Data Validation:
Select the cells DataData Validation Allow: (check out the number options: whole number, decimal, etc) Does that help? *********** Regards, Ron "Dschro" wrote: Is there a way that, if the cell value exceeds a certain limit, a dialog box would appear? Thanks for any assistance. Dave |
if the cell value exceeds the limit to have a dialog box appea
Ron,
Here's the scenario -- on an Expense Report: If an employee was to fill in any amount in the 'Entertainment' column, a dialog box would pop up asking them to fill out another form needed as documentation for that expense. And If they entered an amount $50 for their 'Total Meals' (including breakfast, lunch and dinner) for any particular day, then the same dialog box would appear. Thanks in advance. Dave "Ron Coderre" wrote: Check Data Validation: Select the cells DataData Validation Allow: (check out the number options: whole number, decimal, etc) Does that help? *********** Regards, Ron "Dschro" wrote: Is there a way that, if the cell value exceeds a certain limit, a dialog box would appear? Thanks for any assistance. Dave |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com