Export (0) Print
Expand All

FormatCondition.Modify Method 

Modifies an existing conditional format.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim Type As XlFormatConditionType
Dim Operator As Object
Dim Formula1 As Object
Dim Formula2 As Object
Dim formatCondition1 As FormatCondition
formatCondition1.Modify(Type, Operator, Formula1, Formula2)

void Modify(
	[In] XlFormatConditionType Type, 
	[In, Optional] object Operator, 
	[In, Optional] object Formula1, 
	[In, Optional] object Formula2
);
public void Modify(
	/*in*/XlFormatConditionType Type, 
	/*in*/System.Object Operator, 
	/*in*/System.Object Formula1, 
	/*in*/System.Object Formula2
);
function Modify(
	 Type : XlFormatConditionType, 
	 Operator : Object, 
	 Formula1 : Object, 
	 Formula2 : Object
);

Parameters

Type

Required XlFormatConditionType. Specifies whether the conditional format is based on a cell value or an expression. Can be one of the following XlFormatCondition constants:

xlCellValue

xlExpression

Operator

Optional XlFormatConditionOperator. The conditional format operator. Can be one of the following XlFormatConditionOperator constants:

xlBetween

xlEqual

xlGreater

xlGreaterEqual

xlLess

xlLessEqual

xlNotBetween

xlNotEqual

If Type, is xlExpression, the Operator argument is ignored.

Formula1

Optional Object. The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.

Formula2

Optional Object. The value or expression associated with the conditional format. Can be a constant value, a string value, a cell reference, or a formula.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft