Pivot row background color

  • Thread starter Thread starter jaya
  • Start date Start date
J

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
 
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
 
Back
Top