To do this for an individual cell, modify the Formatting.Font property of the Cell object. To change the font characteristics for a range of cells, call the CellRange.BeginUpdateFormatting method for this range, modify the Font property of the returned Formatting object, and call the CellRange.EndUpdateFormatting method to finalize the modification. For an example, refer to the How to: Change Cell Font and Background Color document. The Border tab of the Format Cells… dialog allows end-users to apply a border around an individual cell or a range of cells and customize border appearance by changing the line style and color. To access and specify cell borders programmatically, use the Borders object. To access this object for an individual cell, use the Formatting.Borders property of the Cell object. To apply borders to a range of cells, call the CellRange.BeginUpdateFormatting method for this range, and specify the Borders property of the returned Formatting object. Then call the CellRange.EndUpdateFormatting method to finalize the modification. For more information, refer to the How to: Add and Remove Cell Borders document.

The Fill tab of the Format Cells… dialog provides end-users with the capability to specify the cell background color and pattern style. To specify the background color programmatically for an individual cell, modify the Formatting.Fill property of the Cell object. To change font characteristics for a range of cells, call the CellRange.BeginUpdateFormatting method for this range, modify the Fill property of the returned Formatting object, and call the CellRange.EndUpdateFormatting method to finalize the modification.

#Where is the dialog box launcher in excel code#.

#Where is the dialog box launcher in excel how to#.

Excel number format dialog box launcher