Applies the specified ConditionalFormat to the current Cell. If the cell already has a ConditionalFormat, it will be replaced by the specified ConditionalFormat.
public void SetConditionalFormat(ConditionalFormat conditionalFormat)
Public Sub SetConditionalFormat(ByVal conditionalFormat As ConditionalFormat)
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)