Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change info in 1 cell, prompts you for another
I would like to have a promt or some type of notice that when a user changes
the information in cell B15 that it might be necessary to change the information in B25. Ideally, I would want a popup box/notice that says "You've changed the information within, would you like to change XX as well?" Realistically, I would settle for a simple change in cell colour or something similar to indicate that more changes may be needed. Does anyone have any ideas? Thanks! |
#2
|
|||
|
|||
Hi, it's very simple, you should select the cell that you want to have the pop up, then go to Data Validation Imput Message. Put there the message you want and that's all. Saludos NlCO -- NlCO ------------------------------------------------------------------------ NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123 View this thread: http://www.excelforum.com/showthread...hreadid=401077 |
#3
|
|||
|
|||
take a look at datavalidation.You can have a prompt that appears a soon as
the cell is selected -- paul remove nospam for email addy! "redb" wrote: I would like to have a promt or some type of notice that when a user changes the information in cell B15 that it might be necessary to change the information in B25. Ideally, I would want a popup box/notice that says "You've changed the information within, would you like to change XX as well?" Realistically, I would settle for a simple change in cell colour or something similar to indicate that more changes may be needed. Does anyone have any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel | |||
Change cell color dependin on date ... | Excel Worksheet Functions |