Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
Cell 255 character limit and formula | Excel Worksheet Functions | |||
limit number of characters in a cell | Excel Discussion (Misc queries) |