Although conditional formatting is one of Excel's most powerful features, it's a nuisance to turn it on and off through the menus and dialog boxes of the GUI. Adding checkboxes to your worksheet that turn formatting on and off makes it much easier to read data in any way you want, whenever you want.
Conditional formatting, a feature available since Excel 97, applies formats to selected cells that meet criteria based on values or formulas you specify. Although conditional formatting is usually applied based on cell values, applying it based on formulas provides the flexibility to extend the conditional formatting interface all the way to the spreadsheet grid.
The checkboxes from the Forms toolbar
return either a
value (checked/not checked) to their linked cell. By combining a
checkbox from the Forms toolbar with conditional formatting using the
Is option (shown in
Figure 2-1), you can turn conditional formatting on
and off via a checkbox.
Figure 2-1. The Conditional Formatting dialog with the Formula Is option
When used in conjunction with a formula (such as the
Is option), conditional
formatting automatically formats a cell whenever the formula result
this reason, any formula you use in this hack must return either