excel

J

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
 
N

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.
 
Top