If the value of Condition.ComparisonType is a comparison between a cell value and a single value (e.g., Condition.Comparison.CellValueEqualTo), Formula1 sets or returns a formula whose result will be compared with each cell value in the set of conditionally formatted cells. If Condition.ComparisonType is a comparison between a cell value and two values (e.g., Condition.Comparison.CellValueBetween), Formula1 sets or returns a formula whose result will be the minimum comparison value. If the value of Condition.ComparisonType is Condition.Comparison.FormulaEvaluation, Formula1 sets or returns a formula that evaluates to true or false . |