Value Limits in a Cell

[frankjh19701]

I need to be able to set a limit on a cell value and be able to warn if
the threshold is about to be breached. For example:

If the maximum limit for a cell is 5,000 and it goes past 5,000, a
warning message would be displayed alerting the limit being surpassed.

The cell is updated from another worksheet, so the value being added
into it is not controlled from this spreadsheet (It's being referenced
in). But, the warning should be seen from either the first spreadsheet
(Where the value is being entered and then referencing the cell in
question in another sheet), or in the spreadsheet where the cell is.
Both would be great, if that's possible. Thank you in advance for
any/all help in this matter.

 

[Gary''s Student]

Consider using conditional formatting. It can be applied to both the cell
you desire to limit as well as the precedent cell.