change info in 1 cell, prompts you for another

R

redb

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!
 
N

NlCO

Hi, it's very simple, you should select the cell that you want to hav
the pop up, then go to Data >> Validation >> Imput Message.

Put there the message you want and that's all.

Saludos NlC
 
P

paul

take a look at data>validation.You can have a prompt that appears a soon as
the cell is selected
 
Top