View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
poetic line poetic line is offline
external usenet poster
 
Posts: 1
Default Need to flag numbers over a certain value

We are working on a payroll spreadsheet. If a number goes into the wrong
column like overtime pay instead of oncall pay, the wrong calculation is
entered. If the number is too high in the overtime pay column, we may be
able to tell that it is in the wrong column. Is their a way to be prompted
that the number is too high for that cell.

Thanks.