Cell Validation

J

jcd110681

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
 
F

Fleone

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(A1>0,"Please enter value","")

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Prevent delete 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation - Preventing Delete from Delete Key 2
If formula and Data Validation parallely 1
help with data validation 2
Data Validation on Locked Cell 2
Max Length in a row 1
macro Excel problem link cells with Data-Validation option 4

Top