software

Is there a way that, if the cell value exceeds a certain limit, a dialog box
would appear?

Thanks for any assistance.

DaveCheck Data Validation:

Select the cells
Datagt;Data Validation
Allow: (check out the number options: whole number, decimal, etc)

Does that help?

***********
Regards,
Ronquot;Dschroquot; wrote:

gt; Is there a way that, if the cell value exceeds a certain limit, a dialog box
gt; would appear?
gt;
gt; Thanks for any assistance.
gt;
gt; Dave
gt;

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 gt;$50 for their 'Total Meals' (including breakfast,
lunch and dinner) for any particular day, then the same dialog box would
appear.

Thanks in advance.

Davequot;Ron Coderrequot; wrote:

gt; Check Data Validation:
gt;
gt; Select the cells
gt; Datagt;Data Validation
gt; Allow: (check out the number options: whole number, decimal, etc)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;Dschroquot; wrote:
gt;
gt; gt; Is there a way that, if the cell value exceeds a certain limit, a dialog box
gt; gt; would appear?
gt; gt;
gt; gt; Thanks for any assistance.
gt; gt;
gt; gt; Dave
gt; gt;