I would like to have grayed-out text in some cells to give users short instructions for that particular cell. If they type something in that cell, the text they input is in plain dark black...but if they delete what they type, the cell goes back to having the grayed-out text.
So just for an example, a cell might say ENTER LAST NAME. When the user starts typing in that cell, ENTER LAST NAME disappears and their text shows up in DARK BLACK. BUT if they delete what they typed, ENTER LAST NAME reappears.
I suppose what I want is conditional formatting which allows me to add text if the cell is empty...but if conditional formatting allows you to 'format' with specific text, I can't find it.
Does anyone have a suggestion?