Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change row color based on condition of celss | Excel Worksheet Functions | |||
Change the color of cells in the pivot table | Excel Discussion (Misc queries) | |||
Change the color of some cells in the pivot table | Excel Discussion (Misc queries) | |||
Color Change in chart based of condition | Charts and Charting in Excel | |||
change background color of row until condition is met | Excel Programming |