Excel Data Validation Custom List. To allow a user to switch between two or more lists you can use the if function to test for a value and conditionally return a list of values based on the result. Select the data cells in all 3 columns not the heading cells on the ribbon s data tab click data validation.
Create Use Dropdown Lists In Excel Drop Down List List Excel from in.pinterest.com
A1 b1 click formatting button change the background or some other colouring so the validation is. To allow a user to switch between two or more lists you can use the if function to test for a value and conditionally return a list of values based on the result. To create a drop down list start by going to the data tab on the ribbon and click the data validation button.
The data validation window will appear.
On the settings tab from the allow drop down choose. Select the last option custom formula one and use the formula. Create a dropdown list. A1 b1 click formatting button change the background or some other colouring so the validation is.
