Pivot row background color

[jaya]

Hi,

I have a pivot table with row labels as client names.
I want to set the back ground color of that column to
light green. how do i do that? autoformat does not have
that format..
-Jaya

 

[Eric]

Jaya,

If I understand your question correctly, you can
definitely make the row labels light green. Just double-
check that you have enabled the selection option.

Right-click in the pivot table then click Select. Is
Enable Selection is not enabled, you need to click on that
option.

After you've verified that, you should be able to
highlight all the row labels by "hovering" your mouse over
the very top of your row title. It should turn to a
little black arrow. When that happens, click and all your
row labels will be selected. If you turn them light green
using this method, that will always be light green.

Hope that helps!

Eric