Data Validation

S

SJT

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.
 
A

Alan

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.
 
Top