Automatic posting of a warning sign

  • Thread starter Thread starter Sid
  • Start date Start date
S

Sid

I am working on excel spreadsheet with formulas and
functions. I want to know if there is a way to warn
someone to use the right formula for a particular
allocation that a person will be doing. A pop-up message
will satisfy the need. Or is there a way to premanently
install it in the system ?

Please let me know

Thanks
Sid
 
Just to add to Debra's excellent advice, there is no method outside of
macros that will look at the formula a user enters. Data validation can look
at the value returned by a formula, but it seems you would have to know the
range of the right answer at least to use that.
 
Back
Top