Conditional Formatting Duplicate and Unique Values
Output: ConditionalFormattingDuplicateUnique.xlsx
public void Run()
{
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.Columns[0].WidthCharacters = 55;
worksheet.Columns.SetWidthCharacters("B", "F", 5);
worksheet["A1"].Value = "Duplicate Numbers";
worksheet.GetRange("B1:F1").SetValue(new[] { 1, 2, 3, 4, 1 });
var ruleB1 = worksheet.ConditionalFormattings.AddDuplicateValues("B1:F1");
ruleB1.Fill = CellFill.CreateSolidFill(SpreadsheetColor.Accent3);
worksheet["A2"].Value = "Unique Numbers";
worksheet.GetRange("B2:F2").SetValue(new[] { 1, 2, 3, 4, 1 });
var ruleB2 = worksheet.ConditionalFormattings.AddUniqueValues("B2:F2");
ruleB2.Fill = CellFill.CreateSolidFill(SpreadsheetColor.Accent2);
worksheet["A3"].Value = "Duplicate Text";
worksheet.GetRange("B3:F3").SetValue(new [] { "AB", "BC", "CD", "DE", "AB" });
var ruleB3 = worksheet.ConditionalFormattings.AddDuplicateValues("B3:F3");
ruleB3.Fill = CellFill.CreateSolidFill(SpreadsheetColor.Accent3);
worksheet["A4"].Value = "Unique Text";
worksheet.GetRange("B4:F4").SetValue(new[] { "AB", "BC", "CD", "DE", "AB" });
var ruleB4 = worksheet.ConditionalFormattings.AddUniqueValues("B4:F4");
ruleB4.Fill = CellFill.CreateSolidFill(SpreadsheetColor.Accent2);
workbook.SaveAs("ConditionalFormattingDuplicateUnique.xlsx");
}