View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
 
Posts: 430
Default when certain number is typed in a cell to display a message

Try 'data'....'validation' then stick your formula and error message in there.

"Wanna Learn" wrote:

Hello I want to display a message "Please contact your Manager" whenever the
number 040 0r 044 is entered into a cell. F another number besides i040 or
044 is entred nothing happens I tried an if formula but that gets
deleted whenever a number is entred in the cell HELP! thanks