In B5 I have a dropdown list with the choices of “Yes” or “No”. B6 is dependant on the answer in B5. I want to make it so if B5 is “No” than B6 will automatically become a zero. If B5 is “Yes” then a dropdown will be available with numbers 0-20. Can I do that? If yes, then how? (I am using Excel 2007)
Bookmarks