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

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

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" wrote:

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

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:

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" wrote:

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