Conditional Formatting on pivot tables

Hello all, I have set a conditional format on the entire worksheet (Ctrl + A) where any value below 0 turns red.

When my pivot table refreshes or udpates, the format no longer works. I am using excel 2007, does anyone have any advice regarding this issue?

Hello, tahnk you i didn;t realise that.

I now have a differnt problem, the coding i'm trying to use (below) doesn't seem to work.

Please Login or Register  to view this content.