Pivot table cell color

[Ashok]

Is it possible to change back color of one cell in Pivot table. Link I want
to give end user option that they can use context menu do some work which
will change back color of one cell in pivot table.

I understand that when pivot table will get refresh either I have to
remember which cell was colored or it will remove.

If not possible to color one cell the at least one row I like to color
different then others.

Thanks for your help - Ashok

 

[Alvin Bruney [MVP]]

have a look at the pivotcell object.

 

[Skinnerfritz]

I was able to get a row colored with the VB script below. It's a matter of
identifying the row/column in question through that axis and setting the
subtotalbackcolor property.

set pNestedRow = objView.RowAxis.FieldSets(1).Fields(0)
pNestedRow.SubtotalBackColor="#FFFFCC"

set pNestedCol = objView.ColumnAxis.FieldSets(1).Fields(0)
pNestedCol.SubtotalBackColor="#FFFFCC"

Hope that helps.
Fritz Skinner