ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/15321-data-validation.html)

JJalomo

Data Validation

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

Peo Sjoblom

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

All times are GMT +1. The time now is 04:39 AM.