Pivots and keeping conditional formatting

[Guest]

Does anyone know a way to keep the conditional formatting on columns when you
select or deselect data columnsIn a pivot table? I have my conditional
formatting set up on a column (i.e., make the cell yellow if number is
greater than 0 for a specfic column) but when I deselect a column around it,
it moves the formatting to a different column. How can I get conditional
formatting to stick on the right areas in a pivot table?
Thanks in advance!

 

[David McRitchie]

Hi Jenn,

I guess you would need a macro to set up your conditional formatting.
John McGimpsey posted some code, he might also have something on his own site.
Macro creating 3 Conditional Formats (#macro)
http://www.mvps.org/dmcritchie/excel/condfmt.htm#macro

Thinking that you run a Pivot table you would only need to run a macro
to set the color banding once, but that was not the case. You can compare the two macros.