How to: Change Cell Font and Background Color
- 2 minutes to read
To change the color characteristics for a range of cells, call the CellRange.BeginUpdateFormatting method for this range, modify the Font and Fill properties of the returned Formatting object, and call the CellRange.EndUpdateFormatting method to finalize the modification.
To share font color and background settings with multiple cells in a single step, create or modify a style with the Formatting.Font and Formatting.Fill properties specified as required, and assign this style to CellRange.Style for the desired cells.
This example demonstrates how to format color characteristics (font and background colors) for an individual cell and range of cells.
A complete sample project is available at https://github.com/DevExpress-Examples/spreadsheet-document-server-api-e4339..
// Format an individual cell. worksheet.Cells["A1"].Font.Color = Color.Red; worksheet.Cells["A1"].FillColor = Color.Yellow; // Format a range of cells. CellRange range = worksheet.Range["C3:D4"]; Formatting rangeFormatting = range.BeginUpdateFormatting(); rangeFormatting.Font.Color = Color.Blue; rangeFormatting.Fill.BackgroundColor = Color.LightBlue; rangeFormatting.Fill.PatternType = PatternType.LightHorizontal; rangeFormatting.Fill.PatternColor = Color.Violet; range.EndUpdateFormatting(rangeFormatting);