I don't think it's possible.
Angus wrote:
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?
" wrote:
Dave Peterson wrote:
Maybe you could just apply Data|filter|autofilter to your original data range
and filter to show what you need to see.
Angus wrote:
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
Thank's
Ashish singh
--
Dave Peterson
|