Please view the attached screenshot -
Cell B7, is a drop down. The two items you can select are "Square / Rectangle" or "Cylinder". If the user has selected the first option, then I don't want anything to happen.
But, if the user selects "Cylinder", then between cells C7 and D7, ONLY ONE can accept a value.
The screenshot doesn't show this, but if "Cylinder" is selected, then "Width" & "Depth" change to "Diameter" & "Circumference". In that case, the user should only be giving me one answer between both of those cells.
Thank you in advance for your help!