I want to show "Enter Text Here" in fade color in a cell, say C5, when it is empty.

As per my knowledge, it can't be done by Conditional Formatting.

One way I found is to create a transperent Text Box Mask linked with other cell. But masking text box is time consuming, especially if I have more than 10 cells to show the text.

Is there any VBA code to solve this problem??