Change pivot Table color on Condition
 

Hi,

I use a vbscript to load an external cube file into html
file. I can change the caption and format of the pivot
table totals. I have a total called sale percent change.
It should be shown in red color when negative a dn black
when positive.

set pview = PivotTable1.ActiveView
pview.Totals("Percent Change").NumberFormat = "%#0.00"
pview.Totals("Percent Change").Caption= "% Change"

Can anybody tell me how I can do that?

THanks so much for any help.