How to: Apply Color to Excel Ranges

To apply a color to text within a range of cells, use a NamedRange control or a native Excel range object.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

Using a NamedRange Control

This example is for document-level customizations.

Create a NamedRange control at cell A1.

Dim rng As Microsoft.Office.Tools.Excel.NamedRange = _
    Me.Controls.AddNamedRange(Me.Range("A1"), "NamedRange1")

Microsoft.Office.Tools.Excel.NamedRange rng =
    this.Controls.AddNamedRange(this.Range["A1", missing], "NamedRange1");

Set the color of the text in the NamedRange control.

rng.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red)

rng.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);

Create a range at cell A1 and then set the color of the text.

Dim rng2 As Excel.Range = Me.Application.Range("A1")
rng2.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red)

Excel.Range rng2 = this.Application.get_Range("A1", missing);
rng2.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);