View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pmms
 
Posts: n/a
Default stop entry of data that causes a negative value from a formula

Excel 2002. I tried to use "Validation" on the "Data" menu but that only
works on entered data. I have a formula in a cell and if the answer becomes
a negative number I want it to stop the user and "force" them to fix it. I
used an IF condition but that only displays a message.