Data Validation Drop Down. The data validation window will appear. In the data validation window use this formula for the 3rd drop down.
You ll want to select list in the drop down menu under allow. Create a table of items or create a list. With data validation you can create a dropdown list of options in a cell.
Remove data validation select the cell or cells that contain the validation you want to delete then go to data data validation and in the data validation dialog press the clear all button then click ok.
Remove data validation select the cell or cells that contain the validation you want to delete then go to data data validation and in the data validation dialog press the clear all button then click ok. If you do so data validation formats will be overwritten by blank cell formatting. To create a drop down list start by going to the data tab on the ribbon and click the data validation button. In the data validation window use this formula for the 3rd drop down.
