Keep conditional format when "show pages" from Pivot table

[Guest]

When I use "show pages" to drill down the data into pages from Pivot table, I
find the conditional format on pivot table is missing. I have to make
conditional format again to every page.

How to keep the conditional formatting when I use "show pages" from pivot
table?

 

[Dave Peterson]

Maybe you could just apply Data|filter|autofilter to your original data range
and filter to show what you need to see.

 

[singh352]

Maybe you could just apply Data|filter|autofilter to your original data range
and filter to show what you need to see.

Thank's
Ashish singh

 

[Guest]

But pivot table and autofilter work for very different purpose, what I need
is to keep original conditional formatting when I use "show page", anyone can
help?

 

[Dave Peterson]

I don't think it's possible.

But pivot table and autofilter work for very different purpose, what I need
is to keep original conditional formatting when I use "show page", anyone can
help?

 

[Dave Peterson]

Well, if your conditional formatting is common for the whole column, maybe you
could just copy|paste special from the original list????

 

[Guest]

Can I copy and paste by VBA? as I will create more than twenty pages by using
"show pages". Could anyone help?

Well, if your conditional formatting is common for the whole column, maybe you
could just copy|paste special from the original list????

 

[Dave Peterson]

Record a macro when you do one set of copying.

Then that macro can be generalized to go through the selected sheets.

So you select the 20 sheets then run that generalized macro.

Post back with the code you've got.

Can I copy and paste by VBA? as I will create more than twenty pages by using
"show pages". Could anyone help?