For instance, can you conditionally format the selected value in a combo box control? The answer is yes, but you won’t use conditional formatting; you’ll use a VBA procedure.

When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.