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?

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

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

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

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

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

Dave Peterson wrote:

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

--

Dave Peterson