How do I display a message when a cell has a certain value??

[lauren]

Hi,

I have a cell where if the cell is empty (A1=0), then I would like the
cell to display "Enter your value here." Otherwise, I would like the
cell to display the value a person enters.

I have tried using an if/then/else statement and, understandably, I
get a circular reference error:

=IF(A1=0,"Enter your value here",A1)

Does anyone have a suggestion?

Thanks!

 

[Pete_UK]

You would need some VBA code to do this. However, you could put this
formula in B1:

=IF(A1="","<--- Enter your value here","")

which is pointing out to the User that the value should go into A1
(the message disappears when there is something in A1).

Or you could think about using Data | Validation on cell A1, with an
Input Message which shows when A1 is selected. This would also allow
you to restrict what is entered into A1.

Hope this helps.

 

[Lori]

Maybe with a custom number format e.g.:

General;General;"Enter your value here"

 

[laureny55]

Thanks, Pete. I'm using your suggestion.

 

[laureny55]

I'm sorry Lori, I don't think I understand what you mean.
What should I enter in the 'General' field??

General;General;"Enter your value here"