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!