You can't do it via formulae but try to use Conditional formatting, e.g. cell
turns to red when stock-orders is at a minimum level.

Regards,
Stefi

€žfabio€� ezt Ã*rta:

Hi

Is it possible to get a warning message appear when a cell value hits a
certain value using standard Excel functions rather than VBA. Basically
looking at an order vs stock situation so when the orders reduce stock to a
minimum level a warning comes up. Like Data Validation but want it to do it
based on the result of a formula in the cell not physically typing in the
result of stock-orders.

Thanks

Belarus or bust