View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Excel 2007 Pivot Tables - do not display zero values

You can use conditional formatting to set the foreground colour to
white if the cell contents are zero.

Hope this helps.

Pete

On Mar 10, 2:19*pm, Barb Reinhardt
wrote:
How do I set my pivot table so that it does not display any sums of values
that are equal to zero?

Thanks,

Barb Reinhardt