Question
Is there a quicker way to add validation script to multiple dropdown lists?
if (event.value=="VD")
event.target.fillColor = color.gray;
else if (event.value=="OD")
event.target.fillColor = color.ltGray;
else event.target.fillColor = color.transparent;
