View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default 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