View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Is it possible to add conditional formatting in a pivot-table?

You can't add conditional formatting to items or specific data in a
pivot table. It's applied to the cells, and may show incorrect results
if the pivot table layout is changed.

Saddy wrote:
Hi all!

I wonder if it is possible to add conditional formatting features to
highlight certain data within a pivot-table. All I could do until now is to
highlight the data I want via the normal way. That is, adding conditional
fomatting conditions to a group of cells, but when I change the pivot layout,
I lose everything.

Thanks for your help!

Raphael




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html