Class ExcelConditionalFormattingIconDataBarValue¶

18.3.1.11 cfvo (Conditional Format Value Object) Describes the values of the interpolation points in a gradient scale.

public class ExcelConditionalFormattingIconDataBarValue

Properties¶

If not custom is null. If user assigns to it holds icon value.

public eExcelconditionalFormattingCustomIcon? CustomIcon { get; set; }

The Formula of the Object Value

Keep in mind that Addresses in this property should be Absolute not relative

Yes: $A$1

No: A1

public string Formula { get; set; }

Greater Than Or Equal To Set to false to only apply an icon when greaterThan

public bool GreaterThanOrEqualTo { get; set; }

Value type

public eExcelConditionalFormattingValueObjectType Type { get; set; }

The value

public double Value { get; set; }