AddDuplicateCondition Method

Adds a new DuplicateConditionalFormat instance to this collection, configured as a duplicate value condition.

Syntax

Visual Basic

'Declaration
 
Public Function AddDuplicateCondition( _
   ByVal regionAddress As String _
) As DuplicateConditionalFormat

C#

public DuplicateConditionalFormat AddDuplicateCondition( 
   string regionAddress
)

Parameters

regionAddress

A string identifying the region to which this conditional format applies.

Return Value

The resulting DuplicateConditionalFormat instance.

Remarks

Use this method to add a condition which evaluates to true only for cell values which are non-unique across the associated range.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2