Automatically reapply conditional formatting in a pivot?

[treeantz]

hi all, I am having a lot of troubles trying to retain conditional formatting in one of my pivot tables. For now, i am using a macro to help me apply the coloring but this has to be done manually.

Is there a way to automatically color the fields after a Refresh All? Possibly with the help of VBA?

Thanks in advance.

 

[Derek Brown]

You did not say which version of Excel is being used.
The podcast at the following link demonstrates how this can be done in Excel 2003 - I have not tried it in later versions of Excel.
http://www.youtube.com/watch?v=13tQaB3TgSs

 

[treeantz]

i am currently on Office 2010. i will check out the podcast in the meantime.
Thanks.