can excel alert you when a number is less than a particular value

[Megglesface]

I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this?

 

[Pete_UK]

If stock is in A1:

=IF(A1<15,"Warning","")

Hope this helps.

Pete

 

[Dave]

Hi,
Another way is to use Conditional Formatting.
This is a very effective tool for this sort of requirement.
It's very simple to use, but see the Help on how to get started.
Regards - Dave.

 

[Megglesface]

brilliant, thanks very much.

sorry to be a pain but maybe you could help with my other question?
If I want to use a cell value in a formula, but the cell is from another
worksheet in the same book, how do I do this? I thought I just entered = into
the formula box then clicked onto the other worksheet and selected the cell,
but that doesnt seem to be working,

little bit confused. ;-S

Thanks

 

[Pete_UK]

If you want to enter the formula directly, you would have something
like:

=Sheet2!A1

but the method you describe should give you this. If you have spaces
in the sheet name then you have to enclose it with apostrophes like
so:

='Sheet 2'!A1

Hope this helps.

Pete

 

[Megglesface]

brilliant thats worked perfectly, just needed the apostrophes I think.
thanks very much, been struggling with that one all day!

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

 

[Megglesface]

no worries.

Im making a range of spreadsheets to control stock orders, simple i guess
but I havnt done it before and no one else at the office has either, so its a
case of teaching myself.

must say, this forum is much better for answers than using the automatic
help guide.