Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a data validation that does not permit the user to enter a number in a cell if the value in another cell is greater than 0. How do I set that up? Thanks for your help.
 
In validation, select Custom and in the formula window enter
=A1=0
Regards,
SJT said:
I would like to create a data validation that does not permit the user to
Click to expand...
enter a number in a cell if the value in another cell is greater than 0.
How do I set that up? Thanks for your help.
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
How to do - B2 is only valid if B1 is zero 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation on Locked Cell 2
#VALUE# error with Data Validation 1
Data Validation formulas 4
DATA Validation (Ignore Blanks) 3
Data validation formulas 1

Back
Top