I'd like Excel 2007 to display a certain text like "" as long as a cell is empty.
So if the user writes text in the cell, this written text shall be displayed, and if the user removes this text, so that the cell is empty, the above mentioned text should be displayed again automatically.
Is there a way to do that (without VBA)?
I tried with custom number formatting
0;0;"<please insert your comment here>";@,
but I can only specify a text for value "0" (which is not the same as empty), but I did not see a way to define if text has been entered or not.