I'm involved in a project where we have to allow the user to select from a list of projects that could be thousands of items long, which obviously won't work using a DropDownList.<BR><BR>Right now ...

Preview and verify all the rules that you’ve applied to the dropdown list items and click on OK. Now you have a color-coded dropdown list in cell B2.

To move an item in the dropdown list: Click-and-hold the six-dot icon to the left of an item, drag it up or down, and release it in a new spot on the dropdown list. To assign a color to an item in ...