ExcelBanter - Need to flag numbers over a certain value

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/383301-re-need-flag-numbers-over-certain-value.html)

Gary''s Student

Need to flag numbers over a certain value

Try Conditional Formatting
--
Gary''s Student
gsnu200706

"poetic line" wrote:

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 11:42 PM.