When changing the border property, these boolean values determine if the lines are changed to the style contained in the respective. Here you can choose from conditions including less than, greater than, between, and others. Apply the Conditional Formatting You have typed your figures, inserted your formulas in the cells, and now you wish to add some colors In our example, the colors are to be displayed in cell B9 1.Select the cell B9, 2.in the Format menu, choose Conditional Formatting, 3. If you select cell value is, the Cell Value Condition box is displayed, as shown in the example. The value false means the cells are formatted differently and the content of the. Specifies whether conditional formatting is dependent on a cell value or on a formula. If the property contains the value true, the line style is equal in all cells that include the line. The boolean members Is.LineValid specifies the validity of the. Each line is represented by a struct .BorderLine that contains the line style and color. A cell range contains six different kinds of border lines: upper, lower, left, right, horizontal inner, and vertical inner line. The cell border style is stored in the struct .TableBorder. Changing the property values affects all cells of the object being formatted. The service contains all properties that describe the cell formatting of the cell range, such as the cell background color, borders, the number format and the cell alignment. These properties are accessible through the interface .XPropertySet that is supported by all the objects mentioned above. In cells, cell ranges, table rows, table columns and cell ranges collections, the cells are formatted through the service .CellProperties.
0 Comments
Leave a Reply. |