This is a crazy question but.........I want to have a cell display a message when it is empty, then when new text is added to display that. When new new text is removed I would like to have it revert back to the default test message that was originally put in.
I know how to do this if I input the text in another cell using an "if" statement, but is there any way to do it all in one cell?
I can't see how but you guys amaze me sometimes.
Thanks,
Mark Miller
Bookmarks