ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need to flag numbers over a certain value (https://www.excelbanter.com/excel-programming/383306-need-flag-numbers-over-certain-value.html)

poetic line

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.


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com