Not a good sign. This didn't work. I put the code exactly as below into
the vba in the window for this sheet, but nothing.

Did this work for you? Tx. :oD


"Sandy" wrote in message
oups.com...
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