Figure A We’ll create two Excel drop down lists based on this simple data set. We need two Excel drop down lists. The first Excel drop down list will set the condition, the region.

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros.

Adding color is a helpful visual tool, whether you’re trying to identify the drop-down cell or a selected item from the list. The demonstration file contains both drop-downs, complete with all ...