Wiki Markup |
---|
{description} {excerpt}Sets or returns the [Style|Condition.Style] that will be set on conditionally formatted cells when the current [Condition|Condition] is met.{excerpt} {signature:C#} public Style Style{ get; set; } {signature}{signature:vb.net} Public Property Style() As Style {signature} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Range rng = wb.Worksheets[0].CreateRange("$B$2:$F$10"); ConditionalFormat condFmt = wb.CreateConditionalFormat(); Condition cond = condFmt.CreateCondition( Condition.Comparison.CellValueGreaterThan, "=100"); Font fnt = cond.Style.Font; fnt.Bold = true; fnt.Color = wb.Palette.GetClosestColor(100, 100, 255); rng.SetConditionalFormat(condFmt); {code} {code:vb.net|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim rng As Range = wb.Worksheets(0).CreateRange("$B$2:$F$10") Dim condFmt As ConditionalFormat = wb.CreateConditionalFormat() Dim cond As Condition = _ condFmt.CreateCondition( _ Condition.Comparison.CellValueGreaterThan, _ "=100") Dim fnt As Font = cond.Style.Font fnt.Bold = true fnt.Color = wb.Palette.GetClosestColor(100, 100, 255) rng.SetConditionalFormat(condFmt) {code} {example} |
Page History
Overview
Content Tools