Pivot table, new rows, format

[chuaby]

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

 

[Debra Dalgleish]

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.