Set the font properties (font-name, color, size, etc.) of cells.
Overload Name | Description |
---|---|
General | Set cell font properties. |
Set cell font properties.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Font | Font to apply. |
Style |
Regular, Italic, Bold, or BoldItalic.
Specify one of the following values or an arbitrary value:
<blank> Regular Italic Bold BoldItalic
|
Size |
Font size to apply.
Specify one of the following values or an arbitrary value:
<blank> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
Underline |
None, Single, Double, SingleAccounting, DoubleAccounting.
Specify one of the following values or an arbitrary value:
<blank> Single SingleAccounting Double DoubleAccounting None
|
Color |
Excel color palette index to use for Font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
ColorValue (8.0) | Select a specific color using the color selector. |
StrikeThrough |
Whether to apply Font strikethrough format.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Superscript |
NOT SUPPORTED?: Whether to apply Font superscript format.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Subscript |
NOT SUPPORTED?: Whether to apply Font subscript format.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|