title: EPPlus Conditional Formatting
body: <p>I've tried to follow this one: <a href="https://stackoverflow.com/questions/13196762/conditional-formatting-by-expression-using-epplus">Conditional Formatting by Expression using EPPlus</a></p>
  
  <p>But in my case, the excel file was <strong>corrupted</strong> and give me option to recover with rule removed.</p>
  
  <p>I want to achieve this (simplified):
  <a href="https://i.stack.imgur.com/vZTfc.png" rel="nofollow noreferrer">screenshot</a></p>
  
  <p>Here's my codes (for column A):</p>
  
  <pre><code>ExcelWorksheet ew = ep.Workbook.Worksheets.Add("Sheet1");
  
  var cells = new ExcelAddress("A2:A5");
  string formula = "ISNUMBER(SEARCH($A$1;C2))";
  var condition = ew.ConditionalFormatting.AddExpression(cells);
  condition.Formula = formula;
  condition.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
  condition.Style.Fill.BackgroundColor.Color = System.Drawing.Color.Yellow;
  </code></pre>
  
  <p>Thanks in advance</p>