officefileapi-devexpress-dot-spreadsheet-dot-cellrange-8aab47f6.md
Gets or sets the cell background color.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
Color FillColor { get; set; }
Property FillColor As Color
| Type | Description |
|---|---|
| Color |
The cell background color.
|
Use properties of the Fill object to specify background settings for a cell:
FillColor)When you specify FillColor or BackgroundColor for a cell with no background (Fill.PatternType is None), the cell background pattern is changed to Solid.
Important
The semi-transparent alpha component (the Color‘s alpha parameter with a value less than 255) is reset to opaque (255) when the document is rendered in the Spreadsheet control, printed, or exported to PDF and Excel formats.
To access the Fill object, use the Formatting.Fill property.
For examples on how to specify formatting for an individual cell and cell range or modify a style, refer to the How to: Format a Cell or Range of Cells or How to: Create or Modify a Style document.
This example demonstrates how to format color characteristics (font and background colors) for an individual cell and range of cells.
// 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:H10"];
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);
' Format an individual cell.
worksheet.Cells("A1").Font.Color = Color.Red
worksheet.Cells("A1").FillColor = Color.Yellow
' Format a range of cells.
Dim range As CellRange = worksheet.Range("C3:H10")
Dim rangeFormatting As Formatting = 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)
The following code snippets (auto-collected from DevExpress Examples) contain references to the FillColor property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
winforms-spreadsheetcontrol-api-part1/CS/SpreadsheetControl/SpreadsheetActions/FormulaActions.cs#L29
worksheet.Cells["B1"].Value = "Value";
worksheet.Range["A1:B1"].FillColor = Color.LightGray;
worksheet.Range["A1:B2"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
worksheet.Cells["B1"].Value = "Value";
worksheet.Range["A1:B1"].FillColor = Color.LightGray;
worksheet.Range["A1:B2"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
worksheet.Cells["B1"].Value = "Value";
worksheet.Range["A1:B1"].FillColor = Color.LightGray;
worksheet.Cells["A2"].Value = "'= (1+5)*6";
// Highlight data validation ranges.
worksheet["H4:H9"].FillColor = Color.LightGray;
int[] MyColorScheme = new int[] { 0xFFC4C4, 0xFFD9D9, 0xFFF6F6, 0xFFECEC, 0xE9D3D3, 0xFFDFC4, 0xFFDAE9};
// Highlight data validation ranges.
worksheet["H4:H9"].FillColor = Color.LightGray;
int[] MyColorScheme = new int[] { 0xFFC4C4, 0xFFD9D9, 0xFFF6F6, 0xFFECEC, 0xE9D3D3, 0xFFDFC4, 0xFFDAE9};
worksheet.Cells("B1").Value = "Value"
worksheet.Range("A1:B1").FillColor = Color.LightGray
worksheet.Cells("A2").Value = "'= (1+5)*6"
winforms-spreadsheetcontrol-api-part1/VB/SpreadsheetControl/SpreadsheetActions/FormulaActions.vb#L26
worksheet.Cells("B1").Value = "Value"
worksheet.Range("A1:B1").FillColor = Color.LightGray
worksheet.Range("A1:B2").Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center
worksheet.Cells("B1").Value = "Value"
worksheet.Range("A1:B1").FillColor = Color.LightGray
worksheet.Range("A1:B2").Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center
' Highlight data validation ranges.
worksheet("H4:H9").FillColor = Color.LightGray
Dim MyColorScheme() As Integer = { &HFFC4C4, &HFFD9D9, &HFFF6F6, &HFFECEC, &HE9D3D3, &HFFDFC4, &HFFDAE9}
' Highlight data validation ranges.
worksheet(CStr(("H4:H9"))).FillColor = System.Drawing.Color.LightGray
Dim MyColorScheme As Integer() = New Integer() {&HFFC4C4, &HFFD9D9, &HFFF6F6, &HFFECEC, &HE9D3D3, &HFFDFC4, &HFFDAE9}
See Also