Page History

{description}
{excerpt}A [Condition|Condition] object represents a condition within a [ConditionalFormat], a format that Excel will apply to a cell or group of cells if a specified condition is met. {excerpt}
{signature:C#}
 public sealed class Condition
{signature}{signature:vb.net}
Public NotInheritable Class Condition
{signature}
{remarks}A [ConditionalFormat|ConditionalFormat] object contains up to three {{Condition}} objects and a [Range] object representing the set of cells on which the conditions will be tested.

To create a {{Condition}} object, call one of the {{ConditionalFormat}} object's [CreateCondition|ConditionalFormat.CreateCondition] methods.
{remarks}
{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}
{properties}
||Name||Description||
|[ComparisonType|Condition.ComparisonType]|{excerpt-include:Condition.ComparisonType|nopanel=true}|
|[Formula1|Condition.Formula1]|{excerpt-include:Condition.Formula1|nopanel=true}|
|[Formula2|Condition.Formula2]|{excerpt-include:Condition.Formula2|nopanel=true}|
|[Style|Condition.Style]|{excerpt-include:Condition.Style|nopanel=true}|
{methods}
||Name||Description||
|[ApplyStyle(Style)|Condition.ApplyStyle(Style)]|{excerpt-include:Condition.ApplyStyle(Style)|nopanel=true}|
|[ChangeCondition(Condition.Comparison, String)|Condition.ChangeCondition(Condition.Comparison, String)]|{excerpt-include:Condition.ChangeCondition(Condition.Comparison, String)|nopanel=true}|
|[ChangeCondition(Condition.Comparison, String, String)|Condition.ChangeCondition(Condition.Comparison, String, String)]|{excerpt-include:Condition.ChangeCondition(Condition.Comparison, String, String)|nopanel=true}|
{classes}
||Name||Description||
|[Comparison|Condition.Comparison]|{excerpt-include:Condition.Comparison|nopanel=true}|