Data Validation

J

JJalomo

How do I allow entry into a cell only if another cell meets certain criteria?

Example if cell a4 contains "Inactive" do not allow input into B4, If cell
a4 contains "Active" allow any numeric value
 
Top