Reset a column of listboxes

Hi,

I have about 300 rows and in column C I have a list box which has either 'YES' or 'NO' in it. Is there a way that I can create a button or an if statement sort of condition to default all of these to 'NO', kinda like a RESET on this column.

Thanks

that is data validation not list boxes you can simply use

Please Login or Register  to view this content.