function localizeValidation() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns());
  var rules = range.getDataValidations();
  for (var i = 0; i < rules.length; i++) {
    for (var j = 0; j < rules[0].length; j++) {
      if (rules[i][j] && rules[i][j].getCriteriaType() == SpreadsheetApp.DataValidationCriteria.VALUE_IN_RANGE) {
        var cValues = rules[i][j].getCriteriaValues();
        cValues[0] = sheet.getRange(cValues[0].getA1Notation());
        rules[i][j] = rules[i][j].copy().withCriteria(SpreadsheetApp.DataValidationCriteria.VALUE_IN_RANGE, cValues).build();
      }
    }
  }
  range.setDataValidations(rules);
}

function onOpen() {
  SpreadsheetApp.getActiveSpreadsheet().addMenu("Custom", [{name: "Localize Validation",  functionName: "localizeValidation"}]);
}