I currently have a Data validation of Custom formula on a cell, B8, that looks a little like this:=or(and(B7=Yes,isblank(B8)),and(B7=No,B8>=75,B8<=100))`I'd like to turn the latter validation of B8>=75,B8<=100 into a drop-down selection with the numbers 75-100is that possible? I only know you can with the List of items option.
Is it possible to have a Data validation with a Custom formula WITH a dropdown list?
google spreadsheets