Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular value
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular value
If stock is in A1:
=IF(A1<15,"Warning","") Hope this helps. Pete On May 7, 11:52*am, Megglesface wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular value
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" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular va
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" wrote: If stock is in A1: =IF(A1<15,"Warning","") Hope this helps. Pete On May 7, 11:52 am, Megglesface wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular va
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 On May 7, 1:40*pm, Megglesface wrote: 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" wrote: If stock is in A1: =IF(A1<15,"Warning","") Hope this helps. Pete On May 7, 11:52 am, Megglesface wrote: 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?- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular va
brilliant thats worked perfectly, just needed the apostrophes I think.
thanks very much, been struggling with that one all day! "Pete_UK" wrote: 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 On May 7, 1:40 pm, Megglesface wrote: 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" wrote: If stock is in A1: =IF(A1<15,"Warning","") Hope this helps. Pete On May 7, 11:52 am, Megglesface wrote: 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?- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular va
You're welcome - thanks for feeding back.
Pete On May 7, 2:13*pm, Megglesface wrote: brilliant thats worked perfectly, just needed the apostrophes I think. thanks very much, been struggling with that one all day! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel alert you when a number is less than a particular va
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. "Pete_UK" wrote: You're welcome - thanks for feeding back. Pete On May 7, 2:13 pm, Megglesface wrote: brilliant thats worked perfectly, just needed the apostrophes I think. thanks very much, been struggling with that one all day! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel alert/Notification | Excel Worksheet Functions | |||
Excel Macro Alert | Excel Discussion (Misc queries) | |||
Closing Excel without alert | Excel Discussion (Misc queries) | |||
sound alert from excel | Excel Discussion (Misc queries) | |||
Alert in Excel??? | Excel Worksheet Functions |