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

Have you tried Conditional Formatting cells ? (Format/Conditional Formatting).


Regards
BrianB
==============================================


"Colin Morgan" wrote in message ...
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

Hi Brian,

Thanks for helping.

I tried that and gave up after a couple of hours as I'm confused about
how to access the value in a data cell.

Tried playing with the conditional formatting on cell value (but the
cell value is volume not promo value) and formula with GETPIVOTDATA
function, but the MS technote says that it can only access visible
fields. I do not want to see the promo value field in the pivottable as
it will make the table very messy. I just want to change the colour of
the cell based on a value of the sum 0.

Any ideas?

Thanks again

Colin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!