Conditional Data Validation
 

Hello,

I am stuck on a problem with my data validation. In one cell there is a
Yes/No pick list. In the adjacent cell, the user will be required to enter a
number if Yes, and needs to default to 0 if No. Is there anyway to
accomplish this?

Thanks,

Brian