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.
Bookmarks