Thread: Data Validation
View Single Post
  #2   Report Post  
filo666
 
Posts: n/a
Default

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