Populating a combo box isn’t hard, but getting the combo box to communicate with a constantly changing list is a little more difficult. Learn how to populate your combo box with a dynamic list.

Thanks to the linked cell property in Microsoft Excel, it’s super easy to use the selected value as a condition in a macro or conditional formatting rule. Formatting values to categorize them or get ...