Link the combo box to cell C1. If you select the control and enter B, the control’s autocomplete behavior will return Baked Goods & Mixes. If you enter C, ...

12. Select a color from the Color field box, then click Use a Style to Format Text Typed Into an Empty Control and select a style from the list (or not).. JD Sartain / IDG Worldwide. Check Box ...