Hi,

I need to colour individual cells in the data area of a
Pivot Table.

Design:

The product attributes are in two tables - a table of
columns which provides product details and a related
table of date/number value/promotion code relating to the
product details combination.

The product combinations are in the Pivottable rows, the
dates are in the column area and the summed number values
in the data area.

I want to set the background colour of each data field
based upon whether the sum of the promotion codes per
data field is 0 - but I do not want to show the
contents of the promotion code field.

I understand that GETPIVOTDATA needs the promotion field
to be visible.

Is there a way this be done with or without using VBA?

Thanks for helping in advance.

Colin