Hi,
I am looking for simple macros to make cells equal to zero if I enter "No" in specific cells. For example, in A1 I can choose either "Yes" or "No" and then in B1 I want it to automatically write zero if "No" is selected in A1. If "Yes" is selected I can input any values, but I want to override any values that are written in B1 when I choose "No" in A1.

Can anyone help me with this?