[[email protected]]

Hi,

You can do this with Data Validation...

Click the Cell.
In 2007-2010, press Alt+D then release Alt then press L

Set the Allow values you want to enter into that cell, etc

For the Message, go to the Input Message Tab, there you can enter what you want to appear if the cell is selected

Copy the cell and pastespecial/validation into the other cell

For 2003-2000, same process but dont know the shortcut how to go, try it in Data Tab.


Hope it helps,
~jaeson