Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Is it possible to have an alert when some info is entered
in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Yes, this can be done, but the only way I know of is through the use of macros. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Mukesh,
Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Thanks RobN, I think Data Validation should solve
my purpose...just need to play a bit. Thanks. Mukesh "RobN" wrote: Mukesh, Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
RobN, using Data Validation, is it possible to have an
alert only if some criteria is not met....for example I type some text in cell A2, which is data validation cell, I need an alert only if A1 is empty, if its filled, move on....no alert. If its not possible to do so using Data Validation, can you please tell me how I can do using macros. I need alert only if the conditions are not met. Thanks. Mukesh "Mukesh" wrote: Thanks RobN, I think Data Validation should solve my purpose...just need to play a bit. Thanks. Mukesh "RobN" wrote: Mukesh, Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Mukesh,
I don't know if my computer's gone nuts, but I thought selecting cell A2, then selecting Custom in the Allow section of Data Validation, and typing a1<"" in the formula section should have done it. But on my system it's not working. Maybe someone else can help out here, as I'm sure Data Validation will do what you want. Rob "Mukesh" wrote in message ... RobN, using Data Validation, is it possible to have an alert only if some criteria is not met....for example I type some text in cell A2, which is data validation cell, I need an alert only if A1 is empty, if its filled, move on....no alert. If its not possible to do so using Data Validation, can you please tell me how I can do using macros. I need alert only if the conditions are not met. Thanks. Mukesh "Mukesh" wrote: Thanks RobN, I think Data Validation should solve my purpose...just need to play a bit. Thanks. Mukesh "RobN" wrote: Mukesh, Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Rob,
Same here, my computer too gone nuts, its not working! Aparently, its not the computer going nuts, its the formula, hope someone here might be able to help. Thank you Rob for your efforts. Mukesh "RobN" wrote: Mukesh, I don't know if my computer's gone nuts, but I thought selecting cell A2, then selecting Custom in the Allow section of Data Validation, and typing a1<"" in the formula section should have done it. But on my system it's not working. Maybe someone else can help out here, as I'm sure Data Validation will do what you want. Rob "Mukesh" wrote in message ... RobN, using Data Validation, is it possible to have an alert only if some criteria is not met....for example I type some text in cell A2, which is data validation cell, I need an alert only if A1 is empty, if its filled, move on....no alert. If its not possible to do so using Data Validation, can you please tell me how I can do using macros. I need alert only if the conditions are not met. Thanks. Mukesh "Mukesh" wrote: Thanks RobN, I think Data Validation should solve my purpose...just need to play a bit. Thanks. Mukesh "RobN" wrote: Mukesh, Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Mukesh,
Unless someone comes up with a better idea, this should work..... You'll need to use a helper cell, so I'll presume B1 is free to use. In B1 type =A1="" (This will mean if A1 is blank, you'll get a TRUE result in B1) Then select A2 and in data validation type as the formula =B1=FALSE You can hide column B if you don't want to see the TRUE or FALSE result. Otherwise use another cell somewhere else as the helper cell. HTH Rob "Mukesh" wrote in message ... Rob, Same here, my computer too gone nuts, its not working! Aparently, its not the computer going nuts, its the formula, hope someone here might be able to help. Thank you Rob for your efforts. Mukesh "RobN" wrote: Mukesh, I don't know if my computer's gone nuts, but I thought selecting cell A2, then selecting Custom in the Allow section of Data Validation, and typing a1<"" in the formula section should have done it. But on my system it's not working. Maybe someone else can help out here, as I'm sure Data Validation will do what you want. Rob "Mukesh" wrote in message ... RobN, using Data Validation, is it possible to have an alert only if some criteria is not met....for example I type some text in cell A2, which is data validation cell, I need an alert only if A1 is empty, if its filled, move on....no alert. If its not possible to do so using Data Validation, can you please tell me how I can do using macros. I need alert only if the conditions are not met. Thanks. Mukesh "Mukesh" wrote: Thanks RobN, I think Data Validation should solve my purpose...just need to play a bit. Thanks. Mukesh "RobN" wrote: Mukesh, Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Rob,
I figured it out! ....you just have to untick the "ignore blank" and formula " =A1<0 " works! Thank you sooo much for your efforts to sort this out. Thanks again. Mukesh "RobN" wrote: Mukesh, Unless someone comes up with a better idea, this should work..... You'll need to use a helper cell, so I'll presume B1 is free to use. In B1 type =A1="" (This will mean if A1 is blank, you'll get a TRUE result in B1) Then select A2 and in data validation type as the formula =B1=FALSE You can hide column B if you don't want to see the TRUE or FALSE result. Otherwise use another cell somewhere else as the helper cell. HTH Rob "Mukesh" wrote in message ... Rob, Same here, my computer too gone nuts, its not working! Aparently, its not the computer going nuts, its the formula, hope someone here might be able to help. Thank you Rob for your efforts. Mukesh "RobN" wrote: Mukesh, I don't know if my computer's gone nuts, but I thought selecting cell A2, then selecting Custom in the Allow section of Data Validation, and typing a1<"" in the formula section should have done it. But on my system it's not working. Maybe someone else can help out here, as I'm sure Data Validation will do what you want. Rob "Mukesh" wrote in message ... RobN, using Data Validation, is it possible to have an alert only if some criteria is not met....for example I type some text in cell A2, which is data validation cell, I need an alert only if A1 is empty, if its filled, move on....no alert. If its not possible to do so using Data Validation, can you please tell me how I can do using macros. I need alert only if the conditions are not met. Thanks. Mukesh "Mukesh" wrote: Thanks RobN, I think Data Validation should solve my purpose...just need to play a bit. Thanks. Mukesh "RobN" wrote: Mukesh, Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to have an alert in Excel?
Mukesh,
Glad you found the problem. Obviously my brain was only half engaged. Rob "Mukesh" wrote in message ... Rob, I figured it out! ....you just have to untick the "ignore blank" and formula " =A1<0 " works! Thank you sooo much for your efforts to sort this out. Thanks again. Mukesh "RobN" wrote: Mukesh, Unless someone comes up with a better idea, this should work..... You'll need to use a helper cell, so I'll presume B1 is free to use. In B1 type =A1="" (This will mean if A1 is blank, you'll get a TRUE result in B1) Then select A2 and in data validation type as the formula =B1=FALSE You can hide column B if you don't want to see the TRUE or FALSE result. Otherwise use another cell somewhere else as the helper cell. HTH Rob "Mukesh" wrote in message ... Rob, Same here, my computer too gone nuts, its not working! Aparently, its not the computer going nuts, its the formula, hope someone here might be able to help. Thank you Rob for your efforts. Mukesh "RobN" wrote: Mukesh, I don't know if my computer's gone nuts, but I thought selecting cell A2, then selecting Custom in the Allow section of Data Validation, and typing a1<"" in the formula section should have done it. But on my system it's not working. Maybe someone else can help out here, as I'm sure Data Validation will do what you want. Rob "Mukesh" wrote in message ... RobN, using Data Validation, is it possible to have an alert only if some criteria is not met....for example I type some text in cell A2, which is data validation cell, I need an alert only if A1 is empty, if its filled, move on....no alert. If its not possible to do so using Data Validation, can you please tell me how I can do using macros. I need alert only if the conditions are not met. Thanks. Mukesh "Mukesh" wrote: Thanks RobN, I think Data Validation should solve my purpose...just need to play a bit. Thanks. Mukesh "RobN" wrote: Mukesh, Try using Data Validation which will do what you want. Have a play with that and post back if you have problems. Rob "Mukesh" wrote in message ... Is it possible to have an alert when some info is entered in any particular cell? for example if I enter 1 in Cell A1, can I have an alert saying "check data in cell D4" ? Thanks. Mukesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel alert you when a number is less than a particular value | Excel Worksheet Functions | |||
Excel alert/Notification | Excel Worksheet Functions | |||
Excel Macro Alert | Excel Discussion (Misc queries) | |||
Email alert from Excel | Excel Worksheet Functions | |||
Alert in Excel??? | Excel Worksheet Functions |