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?