GrapeCity.Documents.Excel.DupeUnique

DupeUnique Enum

Specifies whether a unique values conditional formatting rule evaluates unique values or duplicate values.

This enumeration is used by IUniqueValues to control whether the rule highlights values that appear only once in the specified range or values that are repeated.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum DupeUnique

Public Enum DupeUnique

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {1}, {2}, {1}, {3}, {4}
};
IUniqueValues condition = worksheet.Range["A1:A5"].FormatConditions.AddUniqueValues();
condition.Interior.Color = Color.Yellow;
condition.DupeUnique = DupeUnique.Unique;

Fields

Name	Description
Duplicate	Displays duplicate values.
Unique	Displays unique values.