title: Conditional formatting on Pivot table with Epplus
body: <p>I am trying to add conditional formatting on my pivot table created from Epplus bu i am not able to do it.</p>
  
  <p>I can add the column colors on regular excel sheet by</p>
  
  <pre><code>using (var range = Pws.Cells[1,1,5,5])
  {
      range.Style.Fill.PatternType = ExcelFillStyle.Solid;
      range.Style.Fill.BackgroundColor.SetColor(colorValue);
  }
  </code></pre>
  
  <p>But when i add the code on pivot table sheet and try to open it it gives a pop up message like "Do you want to replace the content of the destination cell in PivotTable?"</p>
  
  <p>I think its adding the color on top of the pivot table value. Its my guess because i can see the value of pivot table when i dont add the color formatting.</p>
  
  <p>Any one had this issue and is there any work around?</p>