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.