FORMAT CELLS IN PIVOT TABLE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I format cells individually in a pivot table. Depending of the value,
I need to set color for detail or subtotals in a pivot table with two fields
in rows. I used:
Me.PivotTable.ActiveData.Cells(RM,CM).DetailCells(0,0)
but it refers just to the first cell.
Any guides? Thanks.
 
OK, I was playing with VB in Access and now I know how to get value from each
cell in my Pivot List. My big problem is to format the background color of
them. I can set de color for totals, all detail, axis, etc., using ActiveView
property of PivotTable object, but I can't set color for an individually
cell. Somebody knows how to solve my problem?
Thanks.
 
Back
Top