Pivot table cell coloring

Aspose.Cells Product Family
1

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





2

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.