Hello! I have a problem with FormatCondition. I create FormatCondition for this solution
https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-9e77c551-0bcf-4515-9497-fdbf724de9be
var area = new CellArea()
{
EndColumn = 2,
EndRow = 5,
StartColumn = 0,
StartRow = 2
};
{
EndColumn = 2,
EndRow = 5,
StartColumn = 0,
StartRow = 2
};
FormatConditionCollection conds = GetFormatCondition(workbook.Worksheets[0], area);
int idx = conds.AddCondition(FormatConditionType.Expression);
int idx = conds.AddCondition(FormatConditionType.Expression);
FormatCondition cond = conds[idx];
cond.Formula1 = “=MOD(ROW();2)=0”;
cond.Style.BackgroundColor = Color.LightBlue;
cond.Style.Pattern = BackgroundType.Solid;
cond.Priority = 1;
//This method adds formatted conditions.
private FormatConditionCollection GetFormatCondition(Worksheet worksheet, CellArea area)
{
//Adds an empty conditional formattings
int index = worksheet.ConditionalFormattings.Add();
//Get the formatted conditions
FormatConditionCollection formatConditions = worksheet.ConditionalFormattings[index];
//Add the formatted conditions cell area.
formatConditions.AddArea(area);
//Return the formatted conditions
return formatConditions;
}
In Excel FormatCondition exist, but it not work. Cells dont change background color