Wiki Markup |
---|
{description} {excerpt}A [ConditionalFormat|ConditionalFormat] object represents a conditional format that Excel will apply to a cell or group of cells if a specified condition is met. Each {{ConditionalFormat}} object contains up to three [Condition] and a [Range|ConditionalFormat.Range] object representing the set of cells on which the conditions will be tested.{excerpt} {signature:C#} [DefaultMember("Item")] public sealed class ConditionalFormat {signature}{signature:vb.net} <DefaultMember("Item")> _ Public NotInheritable Class ConditionalFormat {signature} {remarks}To create a {{ConditionalFormat}}, call the [Workbook] object's [CreateConditionalFormat|Workbook.CreateConditionalFormat()] method. {remarks} {example} {code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); ConditionalFormat cf = wb.CreateConditionalFormat(); {code} {code:vb.net|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim cf As ConditionalFormat = wb.CreateConditionalFormat() {code} {example} {properties} ||Name||Description|| |[Count|ConditionalFormat.Count]|{excerpt-include:ConditionalFormat.Count|nopanel=true}| |[Range|ConditionalFormat.Range]|{excerpt-include:ConditionalFormat.Range|nopanel=true}| {indexers} ||Name||Description|| |[Item(Int32)|ConditionalFormat.Item(Int32)]|{excerpt-include:ConditionalFormat.Item(Int32)|nopanel=true}| {methods} ||Name||Description|| |[CreateCondition(Comparison, String)|ConditionalFormat.CreateCondition(Condition.Comparison, String)]|{excerpt-include:ConditionalFormat.CreateCondition(Condition.Comparison, String)|nopanel=true}| |[CreateCondition(Comparison, String, String)|ConditionalFormat.CreateCondition(Condition.Comparison, String, String)]|{excerpt-include:ConditionalFormat.CreateCondition(Condition.Comparison, String, String)|nopanel=true}| |[RemoveCondition(Int32)|ConditionalFormat.RemoveCondition(Int32)]|{excerpt-include:ConditionalFormat.RemoveCondition(Int32)|nopanel=true}| |[RemoveCondition(Condition)|ConditionalFormat.RemoveCondition(Condition)]|{excerpt-include:ConditionalFormat.RemoveCondition(Condition)|nopanel=true}| |
Page History
Overview
Content Tools