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.

This is the demonstration file referenced in How to combine Excel's VLOOKUP () function with a combo box for enhanced searching, by Susan Harkins.