Hi,

Is it possible to setdefault value using data validation.
I have 3 values not done,done ,ignored in data validation. i want 'not done' to be the default value. how to do this. im using this in Conditional formating to check the condition