static void AddTimePeriodConditionalFormatting(IWorkbook workbook)
{
workbook.Calculate();
workbook.BeginUpdate();
try
{
Worksheet worksheet = workbook.Worksheets["cfTasks"];
workbook.Worksheets.ActiveWorksheet = worksheet;
#region #TimePeriodConditionalFormatting
// Create the rule to highlight today's dates in cells B2 through B6.
TimePeriodConditionalFormatting cfRule =
worksheet.ConditionalFormattings.AddTimePeriodConditionalFormatting(worksheet["$B$2:$B$6"], ConditionalFormattingTimePeriod.Today);
// 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, 0xF2, 0xAE, 0xE3);
#endregion #TimePeriodConditionalFormatting
// Add an explanation to the created rule.
CellRange ruleExplanation = worksheet.Range["A8:B9"];
ruleExplanation.Value = "Determine the today's task in the TO DO list.";
}
finally
{
workbook.EndUpdate();
}
}
static void AddTimePeriodConditionalFormatting(IWorkbook workbook)
{
#region #TimePeriodConditionalFormatting
workbook.Calculate();
Worksheet worksheet = workbook.Worksheets["cfTasks"];
workbook.Worksheets.ActiveWorksheet = worksheet;
TimePeriodConditionalFormatting cfRule = worksheet.ConditionalFormattings.AddTimePeriodConditionalFormatting(worksheet["$C$5:$C$9"], ConditionalFormattingTimePeriod.Today);
cfRule.Formatting.Fill.BackgroundColor = Color.FromArgb(255, 0xF2, 0xAE, 0xE3);
worksheet["B2"].Value = "Determine the today's task in the TO DO list.";
worksheet.Visible = true;
#endregion #TimePeriodConditionalFormatting
}
