...
Description |
---|
Excerpt |
---|
If the comparison is between a cell value and two values, this is the minimum value; otherwise this is is the formula to be evaluated for the condition. |
Signature | ||||
---|---|---|---|---|
| ||||
public System.String Formula1{ get; set; }
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Property Formula1() As String
{signature}
{remarks}
If the value of [ |
Remarks |
---|
If the value of Condition.ComparisonType |Condition.ComparisonType]is a comparison between a cell value and a single value \(e.g., [Condition.Comparison.CellValueEqualTo |Condition.Comparison#CellValueEqualTo]\), [|Condition.Formula1]sets or returns a formula whose result will be compared with each cell value in the set of conditionally formatted cells. If {{If is a comparison between a cell value and two values \(e.g., [Condition.Comparison.CellValueBetween |Condition.Comparison#CellValueBetween]\), {{
sets or returns a formula whose result will be the minimum comparison value. If the value of {{
is [Condition.Comparison.FormulaEvaluation |Condition.Comparison#FormulaEvaluation], {{
sets or returns a formula that evaluates to {{
or {{
. |
Example | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|