The first excel drop down list will set the condition,.

How to insert drop down list in excel and keep formatting. In the source box, add new list. And then, insert the vba. Web press with left mouse button on the conditional formatting button and a menu appears.

Open the data tab >> from data. Web creating drop down list to begin with, select the cell or cell range to apply data validation ⏩ i selected the cell range e4:e12. First, you make a regular data validation list in one or more cells.

Press with left mouse button on new rule.. If you don't want users to. Then, customize the list using the data validation options.

Alternatively, you can click file > options > customize ribbon. The “ignore blank” check box is checked by default.