Displaying watermark text in a cell without formula

[msry5sm2]

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