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!

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

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!