Share via


Databar.Formula Property

Returns or sets a String representing a formula, which determines the values to which the icon set will be applied.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property Formula As String
    Get
    Set
'Usage
Dim instance As Databar
Dim value As String

value = instance.Formula

instance.Formula = value
string Formula { get; set; }

Property Value

Type: System.String
String

Remarks

This property is useful to limit the range of values that will display the conditional format. A typical scenario is when you have a range of numbers containing both positive and negative values. You may want to create more than one conditional format for this range of numbers—one for positive values and another for negative values.

See Also

Reference

Databar Interface

Databar Members

Microsoft.Office.Interop.Excel Namespace