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