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?