This example demonstrates how to programmatically modify format characteristics (the background color, font and alignment settings) of an individual cell and how to specify different borders for cell ranges.
To format an individual cell, access the corresponding Cell object and modify its formatting properties.
To format a range of cells, modify the Formatting object using the CellRange.BeginUpdateFormatting - CellRange.EndUpdateFormatting method pair.