Hi,

I want to know if it is possible to show the value of data validation already rather that blank cell.

I am thinking that, the data validation is always showing "No" on the cell, but then if we want to change to "Yes" just click the drop down list and then select "Yes"

Thanks