excel

[joe57]

if ihave an excel spreadsheet to use for stock control if A1 is
current stock A2 is order A3 is new stock level how do i show a
message when A3 drops below a certain figure

 

[Norman Harker]

Hi Joe!

You could use:

Conditional Formatting.
Or:
An If function that returns a message when A3 is less than the given
level.
Or:
Use a Worksheet_Change event handling routine that pops up a message.

I'd be inclined to go the Conditional Formatting approach.