Thanks for replying... I was wondering if that would work...
--
HTH...

Jim Thomlinson


"Candyman" wrote:

Perfect! I created an if statement if (x-y0,x-y,1/0). Worked like a charm.

"Jim Thomlinson" wrote:

There is no easy conditional formatting for pivot tables. The only solutions
that I can think of would be to conditionally format the entire column such
that 0 values are White or (I have not tired this but it might work) you
could change for formula to generate an error if the result is going to be
zero. You can format errors to not display via table options.
--
HTH...

Jim Thomlinson


"Candyman" wrote:

How do I make the format of a calculated field equal white if the value is
zero. or the same color as the cell background?