Apply conditional formating to color pivot table cells
 

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