# Optionally set a custom error message dv_match.error ='Your entry is not in the list' dv_match.errorTitle = 'Invalid Entry' # Optionally set a custom prompt message dv_match.prompt = 'Please select from the list' dv_match.promptTitle = 'List Selection' # General column data validation dv_general = DataValidation(type="list", formula1='selections!$A$2:$A$7', allow_blank=True) # Optionally set a custom error message dv_general.error ='You have entered free text' dv_general.errorTitle = 'Free Text' dv_general.errorStyle = 'warning' # Active Verb column data validation dv_active = DataValidation(type="list", formula1='selections!$B$2:$B$6', allow_blank=True) # Optionally set a custom error message dv_active.error ='You have entered free text' dv_active.errorTitle = 'Free Text' dv_active.errorStyle = 'warning' # Focus column data validation dv_focus = DataValidation(type="list", formula1='selections!$C$2:$C$6', allow_blank=True) # Optionally set a custom error message dv_focus.error ='You have entered free text' dv_focus.errorTitle = 'Free Text'
