try this:

right click on the sheet tab where you want C2 to change and select
view code from the menu(on the bottom) then paste this code into the
window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("C2") = Empty Then
Range("C2").Value = "Please enter a value here..."
End If
End Sub


Sandy


StargateFanFromWork wrote:
I had an idea this morning to make my user's lives easier for a particular
spreadsheet. The idea is to have a text string appear in cell C2 if it's
empty, and that is:

"Please enter value here ..."

And then when user enters a value, they'll see the data they've entered into
that cell until/unless they empty the cell.

Is this possible to do?

Again, I've just spent a considerable amount of time in the archives
searching for conditional formatting examples with text strings, but nothing
comes up that's pertinent.

TIA. :oD