Thread: Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Guye Guye is offline
external usenet poster
 
Posts: 19
Default Validation

hi all,
one more short question.
i need to creat on certain columns on a worksheet the following
validation.
the number should be between 0-1000, in case that the nuber is above
500 a message will appear with a certain warning, but the cell will
not be blocked and the value above 500 will be entered as usual.
thanks a lot