We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Pivot table cell coloring

hi aspose team,


i have two data fields in my pivot table,
one is PERCENTAGE field and other is COUNT field.
if count<40 then i want to color percentage field in pivot table.
i can show only percentage field in pivot table.
how could i achieve this.

please ping back me asap


Thanks





Hi,


Aspose.Cells follows MS Excel standards and specifications. How could you apply conditional formattings to Count field in PivotTable, I am not sure if this could be done in MS Excel either. Could you create a sample file with your desired conditional formatting/ formatting applied to the sample PivotTable in MS Excel manually, save the file and post us here, we will check how to do it via Aspose.Cells APIs.

Thank you.