Hello.
Can someone tell me how can I create conditional formatting rule based on excel formula?
I need to implement highlighting for empty cells. I am trying to use ISBLANK excel formula. My current code looks like this:
IExcelConditionalFormattingExpression excelRule = sheet.ConditionalFormatting.AddExpression(range);
excelRule.Style.Fill.BackgroundColor.Color = color;
excelRule.Formula = "ISBLANK( ??? )";
And I cannot figure (or google) a way to reference current cell for CF expression. Or am I entirely on the wrong track?
