What if neither?

--

Regards,

Peo Sjoblom


"JJalomo" wrote in message
...
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