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