I am currently trying to change cell validations cell range in Google Spreadsheet base upon a cell's input.For instance, if A1 = 123 then have B1 (which is the data verification cell) pull from C1:C20, but if A1 = 456 then have B1 cell pull criteria from D1:20.Is this possible?
Data Validation Criteria
google spreadsheets