Pivot table, new rows, format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chuaby@hotmail.com - 06 Oct 2006 04:14 GMT

Hi

i have a little problem with Pivot table when it comes to manual
background colouring. I wish to seek some help please.

The problem is :

if customer 1 has 1 row of data, if Row 1,column 5 is highlighted as
red in background manually, when customer 1 has 2 rows of data, Row 2,
Col 5 (new row of data after refresh) is also higlighted in Red which
is not suppose to be.

if customer 2 has 2 row of data, if Row 2,column 5 is highlight as red
in background, when customer 2 has 3 rows of data, Row 3, Col 5 (new
row of data after refresh) will not be higlighted in Red which is OK,
what i have wanted. That is, i would like to preserve what i have
coloured and not let the Excel highlight for me automatically based on
"previous cell" formatting.

I am using "Preserve formating". May i know is there anyway for me to
overcome the problem for customer 1 ?

Thank you
Boon Yiang

Reply to this Message

Debra Dalgleish - 06 Oct 2006 23:44 GMT

If you select a section of the pivot table, such as all the subtotal
rows, and format them, the formatting should stick. However, if you're
manually selecting rows of data, then changing the pivot table layout,
the formatting may not be preserved, as you've seen.

Perhaps you can use one of the built-in autoformats, which would update
as the pivot table changes.

> Hi
>
[quoted text clipped - 20 lines]
> Thank you
> Boon Yiang

Signature

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

Reply to this Message