Not being 100% sure of what you are trying to accomplish, this would be one
way of doing what you are looking for. Place this formula in cell B1

=IF(A10,"Please enter value","")

As soon as someone typed something in B1, this formula would be overwritten.


" wrote:

I need help in trying on what I think is a validation issue. I'm
trying to get excel to prompt the user to enter information in cell B1
if cell A1 contains data. What would be there formula?

Thanks for the help.

-JD