Conditional Formatting on a Pivot Table

I am trying to put conditional formatting on a pivot table using this:

IConditionalFormats condition = pivotMyPivot.Range["E2:E5000"].ConditionalFormats;

Thank you!

Gina

Hi Steve, 

Thank you for contacting Syncfusion support. 

As per Microsoft Excel behavior, when a pivot table is added in a range where already data exist then the conditional format address in that range will be split into range above and below pivot table. This is the reason for the conditional format address change in the worksheet. So, we suggest you to set the pivot table location below the pivot table data range. The following notification pop up will be displayed in Microsoft Excel when this scenario occurs. 

Screenshot: 

 

If you click “Yes” then the data will be changed, otherwise the pivot table will not be inserted. 

Please let us know if you have any other queries. 

Regards, 

Karthikeyan  

Hi Steve, 

We suspect that the conditional formatting is not applied because of Microsoft Excel refresh the layout of the pivot table while opening the output document. So, we suggest you to use IPivotTable.Layout() method before saving the workbook.  

We have shared a simple sample to achieve your requirement which can be downloaded from the following location. 

Sample Link : http://www.syncfusion.com/downloads/support/forum/140872/ze/XlsIOSample992907393  

 

Kindly try this and let us know whether it helps. 

Regards, 

Karthikeyan  

Hi Steve, 

We are not able to reproduce the issue from our end. So, we request you modify the sample provided in our previous update and share us along with issue reproducing input files. It will be helpful for us to analyze further on this and provide you the solution at earliest. 

Regards, 

Karthikeyan