Displaying watermark text in a cell without formula

Hi,

I am trying to display watermark text in a cell based on the value of another cell. For example:

If in Column B, cell B2 states "Mileage", Column C, cell C2 needs to say "Please enter Start and Destination...". I want column C (cell C2) to be my input cell as well hence the reason i'm avoiding the use of an IF formula.

I'm open to a VBA solution if this works? Tried conditional formatting however it will only display colours, not text?

I have attached an example to explain what I mean.

Thanks

Hi
You can still have a formula in Column C and have it as your input cell when someone makes an entry in Column B.
Make sure that when the setting for moving to the next cell when "Enter" is pressed is set to "Right" and not "Down". That way when the use enters "Mileage" in Cell B2 the message immediately appears in Cell C2 and it will be the active (input) cell. You can have as many as 7 If statements with differing messages if you need them.
Hope this helps.
Good luck.