Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Applies the specified ConditionalFormat to the current
Cell. If the cell already has a ConditionalFormat, it will be replaced by the specified
ConditionalFormat.

Signature
C#
C#
 public void SetConditionalFormat(ConditionalFormat conditionalFormat)
{signature}{signature:
}
Signature
vb.net
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#}
Parameters
Param
conditionalFormat
conditionalFormat

The ConditionalFormat
to apply to the cell.

Example
Code Block
csharp
csharp
titleC#


          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:
Code Block
vb.net
|title=
vb.net
titlevb.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}
Scrollbar