Wiki Markup |
---|
{description} {excerpt}Applies the specified [ConditionalFormat] to the current [Cell|Cell]. If the cell already has a [ConditionalFormat|ConditionalFormat], it will be replaced by the specified {{ConditionalFormat}}.{excerpt} {signature:C#} public void SetConditionalFormat(ConditionalFormat conditionalFormat) {signature}{signature:vb.net} Public Sub SetConditionalFormat(ByVal conditionalFormat As ConditionalFormat) {signature} {parameters} {param:conditionalFormat}The {{ConditionalFormat}} to apply to the cell.{param} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Worksheet ws = wb.Worksheets[0]; 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); ws.Cells[0,0].SetConditionalFormat(condFmt); {code} {code:vb.net|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim ws As Worksheet = wb.Worksheets(0) 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) ws.Cells(0,0).SetConditionalFormat(condFmt) {code} {example} {scrollbar} |
Page History
Overview
Content Tools