3.1 Conditional Formatting

This example shows conditional formatting applied to cell A2 with a "between" condition to make the text red when the value is greater than or equal to 1.5, and less than or equal to 2.5.

The first record in this example is a CondFmt record, which specifies beginning of a collection of CF records and defines the range of cells to which the conditional formatting rule applies. The CF record follows next in this example, defining that conditional formatting rule.

Figure 20: Conditional formatting in this example within a sheet