Hi all,

I need help...

Column A2 (Promotion)
Column B2 (Promotion %)

Rules wanted
1) If A2=Yes, allow enter promotion % in B2.
2) If A2=No, not allow enter promotion % in B2 (may be need to lock the cell?)
3) If I indicate A2=Yes and enter promotion %. Then I change A2=No, need to default the B2 to 0%.

Hope to hear solution soon.