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 you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

Create and populate the spreadsheet, then enter formulas. Now we can create a Conditional Formatting Rule to identify the bills that are due now. Use Conditional Formatting to create Excel Alerts 1.