Hello,

I am having some dramas conditionally formatting pivot tables. I am trying to make all zeros that appear in the pivot table turn yellow (background) this is not a problem until I change the selection and the pivot table changes values and size. The conditional yellow still stays in the same position without the figures being there, so I have this great big yellow column under the pivot table (even though there aren't zeros.

I do not have the same problem with other numbers except zero. Possibly because it see's zero as a blank or something.

Any help would be greatly appreciated,

Regards,

James.