View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nuralain Nuralain is offline
external usenet poster
 
Posts: 2
Default Pivot table -conditional formatting (color)

Hi,

Is it possible to conditionally format the color of cells
in a pivot table based on their values? I've tried
manually using conditional formatting but it's not
retained when the pivot table is changed. I'm new to VBA
and was wondering if there's a way of doing this? and any
example code available?

Thanks,

Nuralain