GrapeCity.Documents.Excel.IUniqueValues.DupeUnique

DupeUnique Property

DupeUnique

Gets or sets if the conditional format rule is looking for unique or duplicate values.

Use this property to determine whether the IUniqueValues rule is configured to match duplicate values or unique values in the applied range.

Declaration

DupeUnique DupeUnique { get; set; }

Property DupeUnique As DupeUnique

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {100}, {100}, {200}, {300}, {300}
};
IUniqueValues condition = worksheet.Range["A1:A5"].FormatConditions.AddUniqueValues();
condition.Interior.Color = Color.Yellow;
condition.DupeUnique = DupeUnique.Unique;
DupeUnique dupeUnique = condition.DupeUnique;