View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JeannieB JeannieB is offline
external usenet poster
 
Posts: 3
Default Carry over formatting in pivot

I guess I wasn't as clear on my first question. How can I carryover the same
font color or cell shading from my list?

Thank you :-)

"Debra Dalgleish" wrote:

If you add number fields to the Row, Column or Report Filter area, they
should keep the formatting from the source data.

If you put the number fields in the Values area they'll have the General
format. You can change the formatting after you add the fields to the
pivot table.

JeannieB wrote:
How do you carry over the formatting of your list onto a pivot table?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com