Range.FillColor Property

Gets or sets the cell background color.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

Color FillColor { get; set; }

VB.NET

Property FillColor As Color

Property Value

Type	Description
Color	A Color value that specifies the cell background color.

Remarks

You can also specify the background characteristics of a cell via the properties of the Fill object: Fill.BackgroundColor (this property is equal to FillColor), Fill.PatternType and Fill.PatternColor. When you specify FillColor or Fill.BackgroundColor for a cell with no background (Fill.PatternType is set to PatternType.None), this cell background pattern type is automatically changed to PatternType.Solid.

To access the Fill object, use the Formatting.Fill property.

• To specify the background of an individual cell, access the Fill object using the cell’s Formatting.Fill property directly.
• To specify the background of a cell range, modify the Fill object within the Range.BeginUpdateFormatting - Range.EndUpdateFormatting method pair.
• To share the same background settings between multiple cells in one step, apply the style with the specified background to the required cells. To specify the cell style background, access the Style object from the IWorkbook.Styles collection and use this style’s Formatting.Fill property within the Formatting.BeginUpdate-Formatting.EndUpdate paired methods to access and modify the Fill object.

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.

Example

This example demonstrates how to format color characteristics (font and background colors) for an individual cell and range of cells.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-e4655

FormattingActions.cs

// Format an individual cell.
worksheet.Cells["A1"].Font.Color = Color.Red;
worksheet.Cells["A1"].FillColor = Color.Yellow;

// Format a range of cells.
Range 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);

FormattingActions.vb

' 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 Range = 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)

Related GitHub Examples

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.

C#

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/FormulaActions.cs#L22

worksheet.Cells["B1"].Value = "Value";
worksheet.Range["A1:B1"].FillColor = Color.LightGray;
worksheet.Cells["A2"].Value = "'= (1+5)*6";

wpf-spreadsheetcontrol-api-part-1-e4938/CS/SpreadsheetControl_WPF_API/SpreadsheetActions/FormulaActions.cs#L24

worksheet.Cells["B1"].Value = "Value";
worksheet.Range["A1:B1"].FillColor = Color.LightGray;
worksheet.Range["A1:B2"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

winforms-spreadsheetcontrol-api-e4655/CS/SpreadsheetControl/SpreadsheetActions/FormulaActions.cs#L23

worksheet.Cells["B1"].Value = "Value";
worksheet.Range["A1:B1"].FillColor = Color.LightGray;
worksheet.Range["A1:B2"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

wpf-spreadsheetcontrol-api-part-3-t289419/CS/SpreadsheetControl_WPF_API_Part03/CodeExamples/DataValidationActions.cs#L68

{
    worksheet.DataValidations[i].Range.FillColor = Color.FromArgb(MyColorScheme[i]);
}

winforms-spreadsheetcontrol-api-part-3-t231273/CS/SpreadsheetControl_API_Part03/CodeExamples/DataValidationActions.cs#L67

{
    worksheet.DataValidations[i].Range.FillColor = Color.FromArgb(MyColorScheme[i]);
}

VB.NET

wpf-spreadsheetcontrol-api-part-1-e4938/VB/SpreadsheetControl_WPF_API/SpreadsheetActions/FormulaActions.vb#L27

worksheet.Cells("B1").Value = "Value"
worksheet.Range("A1:B1").FillColor = Color.LightGray
worksheet.Range("A1:B2").Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center

winforms-spreadsheetcontrol-api-e4655/VB/SpreadsheetControl/SpreadsheetActions/FormulaActions.vb#L27

worksheet.Cells("B1").Value = "Value"
worksheet.Range("A1:B1").FillColor = Color.LightGray
worksheet.Range("A1:B2").Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/FormulaActions.vb#L26

worksheet.Cells("B1").Value = "Value"
worksheet.Range("A1:B1").FillColor = Color.LightGray
worksheet.Cells("A2").Value = "'= (1+5)*6"

wpf-spreadsheetcontrol-api-part-3-t289419/VB/SpreadsheetControl_WPF_API_Part03/CodeExamples/DataValidationActions.vb#L70

For i As Integer = 0 To worksheet.DataValidations.Count - 1
    worksheet.DataValidations(i).Range.FillColor = Color.FromArgb(MyColorScheme(i))
Next i

winforms-spreadsheetcontrol-api-part-3-t231273/VB/SpreadsheetControl_API_Part03/CodeExamples/DataValidationActions.vb#L69

For i As Integer = 0 To worksheet.DataValidations.Count - 1
    worksheet.DataValidations(i).Range.FillColor = Color.FromArgb(MyColorScheme(i))
Next i