Equivalent to choosing the Cells command from the Format menu, and then selecting Font tab from the Format Cells dialog box. This function is included for compatibility with Microsoft Excel version 4.0. Use FONT.PROPERTIES to set various font properties. FORMAT.FONT has three syntax forms. Syntax 1 is for cells; syntax 2 is for text boxes and buttons; syntax 3 is used with all chart items (axes, labels, text, and so on).
Syntax 1
Cells
FORMAT.FONT(name_text, size_num, bold, italic, underline, strike, color, outline, shadow)
FORMAT.FONT?(name_text, size_num, bold, italic, underline, strike, color, outline, shadow)
Syntax 2
Text boxes and buttons on worksheets and macro sheets
FORMAT.FONT(name_text, size_num, bold, italic, underline, strike, color, outline, shadow, object_id_text, start_num, char_num)
FORMAT.FONT?(name_text, size_num, bold, italic, underline, strike, color, outline, shadow, object_id_text, start_num, char_num)
Syntax 3
Chart items including unattached chart text
FORMAT.FONT(color, backgd, apply, name_text, size_num, bold, italic, underline, strike, outline, shadow, object_id_text, start_num, char_num)
FORMAT.FONT?(color, backgd, apply, name_text, size_num, bold, italic, underline, strike, outline, shadow, object_id_text, start_num, char_num)
Arguments correspond to check boxes and list box items in the Font tab on the Format Cells dialog box. Arguments that correspond to check boxes are logical values. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box. If an argument is omitted, the format is not changed.
Name_text is the name of the font as it appears in the Font tab. For example, Courier is a font name.
Size_num is the font size, in points.
Bold corresponds to the Bold item in the Font Style list box. Makes the selection bold, if applicable.
Italic corresponds to the Italic item in the Font Style list box. Makes the selection italic, if applicable.
Underline corresponds to the Underline check box.
Strike corresponds to the Strikethrough check box.
Color is a number from 0 to 56 corresponding to the colors in the Font tab; 0 corresponds to automatic color.
Outline corresponds to the Outline check box. Outline fonts are available in Microsoft Excel for the Macintosh. For macro compatibility, this argument is ignored by Microsoft Excel for Windows.
Shadow corresponds to the Shadow check box. Shadow fonts are available in Microsoft Excel for the Macintosh. For macro compatibility, this argument is ignored by Microsoft Excel for Windows.
Note For macro compatibility with Microsoft Excel for the Macintosh, the presence of the outline and shadow arguments do not prevent the macro from working on Microsoft Excel for Windows, nor does their absence prevent it from working on the Macintosh.
Object_id_text identifies the text box you want to format (for example, "Text 1", "Text 2", and so on). You can also use the object number alone without the text identifier. For compatibility with earlier versions of Microsoft Excel. This argument is ignored in Microsoft Excel version 5.0 or later.
Start_num specifies the first character to be formatted. If start_num is omitted, it is assumed to be 1 (the first character in the text box).
Char_num specifies how many characters to format. If char_num is omitted, Microsoft Excel formats all characters in the text box starting at start_num.
Backgd is a number from 1 to 3 specifying which type of background to apply to text in a chart.
| Backgd | Type of background applied |
| 1 | Automatic |
| 2 | Transparent |
| 3 | Opaque |
Apply corresponds to the Apply To All check box. This argument applies to data labels only.
Remarks
Some extended TrueType styles do not have corresponding arguments to FORMAT.FONT. To access an extended TrueType font style, append the style name to the font name in name_text. For example, the font Taipei can be formatted in an upside-down style by specifying "Taipei Upside-down" as the name_text argument. For more information about TrueType, see your Microsoft Windows documentation.
Related Functions
ALIGNMENT Aligns or wraps text in cells
FONT.PROPERTIES Sets various font attributes
FORMAT.NUMBER Applies a number format to the selection
FORMAT.TEXT Formats a worksheet text box or a chart text item
Return to index