Is there a way that, if the cell value exceeds a certain limit, a dialog box
would appear?
Thanks for any assistance.
Dave
Is there a way that, if the cell value exceeds a certain limit, a dialog box
would appear?
Thanks for any assistance.
Dave
Check Data Validation:
Select the cells
Data>Data 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
>
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
> Data>Data 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
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks