static void AddTextConditionalFormatting(IWorkbook workbook) { #region #TextConditionalFormatting Worksheet worksheet = workbook.Worksheets["cfBooks"]; workbook.Worksheets.ActiveWorksheet = worksheet; TextConditionalFormatting cfRule = worksheet.ConditionalFormattings.AddTextConditionalFormatting(worksheet["$B$5:$B$18"], ConditionalFormattingTextCondition.Contains, "Bradbury"); cfRule.Formatting.Fill.BackgroundColor = Color.FromArgb(255, 0xE1, 0x95, 0xC2); worksheet["B2"].Value = "Quickly find books written by Ray Bradbury in the report below."; worksheet.Visible = true; #endregion #TextConditionalFormatting }
static void AddTextConditionalFormatting(IWorkbook workbook) { workbook.Calculate(); workbook.BeginUpdate(); try { Worksheet worksheet = workbook.Worksheets["cfBooks"]; workbook.Worksheets.ActiveWorksheet = worksheet; #region #TextConditionalFormatting // Create the rule to highlight values with the given text string in cells A2 through A15. TextConditionalFormatting cfRule = worksheet.ConditionalFormattings.AddTextConditionalFormatting(worksheet["$A$2:$A$15"], ConditionalFormattingTextCondition.Contains, "Bradbury"); // Specify formatting options to be applied to cells if the condition is true. // Set the background color to pink. cfRule.Formatting.Fill.BackgroundColor = Color.FromArgb(255, 0xE1, 0x95, 0xC2); #endregion #TextConditionalFormatting // Add an explanation to the created rule. CellRange ruleExplanation = worksheet.Range["A17:G18"]; ruleExplanation.Value = "Quickly find books written by Ray Bradbury."; } finally { workbook.EndUpdate(); } }