Pivot table cell coloring

[bhavana1423]

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

[Amjad_Sahi]

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.