ExcelBanter - Data Validation

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation (https://www.excelbanter.com/excel-worksheet-functions/15530-data-validation.html)

JJalomo

Data Validation

How do I allow input into a cell only if it meets the criteria of another
cell.

If cell c3 contains "Active", allow input into D3
If cell c3 contains "Inactive" do not allow input into D3

filo666

in d3 you will put:
=if(c3="active",[Cell you want to input],"")

"JJalomo" wrote:

How do I allow input into a cell only if it meets the criteria of another
cell.

If cell c3 contains "Active", allow input into D3
If cell c3 contains "Inactive" do not allow input into D3

All times are GMT +1. The time now is 03:01 PM.