Warning Messages

[fabio]

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

 

[Stefi]

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:

 

[fabio]

Thanks Stefi for your time.

Just wondered if I could get something more 'in your face' particularly on a
large spreadsheet where the cells in question may not be in view.

 

[Stefi]

Maybe you can use custom Data validation in such a way:
Say stock is in G2, orders in H2, minimum level in I2, then apply custom
Data validation with formula
=G2-H2>=I2
on H2.

Regards,
Stefi

„fabio†ezt írta: