Itqualityassurance
How do I create a drop down list with conditions?
Click the Data tab and then click Data Validation in the Data Tools group. From the Allow drop down, choose List. In the Source control, enter (or select) $B$2:$E$2 (Figure B). Click OK.
Click the Data tab and then click Data Validation in the Data Tools group. From the Allow drop down, choose List. In the Source control, enter (or select) $B$2:$E$2 (Figure B). Click OK.
