This documentation is archived and is not being maintained.

FormatConditions Interface 

Represents the collection of conditional formats for a single range.

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

'Usage
Public Class ormatConditionsImplementation
	Implements FormatConditions
End Class
Dim ormatConditionsImplementation1 As New ormatConditionsImplementation()

public interface FormatConditions
public interface FormatConditions
public interface FormatConditions

The FormatConditions collection can contain up to three conditional formats. Each format is represented by a FormatCondition object.

Use the FormatConditions property to return a FormatConditions object. Use the Add method to create a new conditional format, and use the Modify method to change an existing conditional format.

If you try to create more than three conditional formats for a single range, the Add method fails. If a range has three formats, you can use the Modify method to change one of the formats, or you can use the Delete method to delete a format and then use the Add method to create a new format.

For more information about conditional formats, see the FormatCondition object.


Development Platforms

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

Target Platforms

Show: