Pivot Table Cells Coloring

[marco]

Hi,

Somebody know how to set backcolor to an specific cell in a pivot table...
I tried using cell object to set color but this has not a property to set
the backcolor.

pt.ActiveData.Cells(pt.ActiveData.rowMembers(0), pt.ActiveData.
columnMembers(0)).aggregates(0).backColor = "Blue"

Do you have an idea about this?

Best Regards!
Ace73

 

[Alvin Bruney - ASP.NET MVP]

have a look at the drillthur sample available on the office website. There's
lots of code available.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/

 

[marco]

Hi Alvin,

Thanks for you reply, I was checking the cell coloring sample that comes
with the Office XP Toolpack and it's something that i'm looking for, but i
need filling with a color the first 3 cells in column 1 and with another
color the first 4 cells in column 2 and so on...

How I can do this with my pivot tables?

Thanks in advanced!
Ace73

 

[marco]

Any Idea??

Best Regards!
Ace73