View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bestrugger bestrugger is offline
external usenet poster
 
Posts: 5
Default Conditional Formatting in a Pivot Table

I didn't think so in Excel 2003. Thanks for the tip. I'll look forward to
doing that in Excel 2007.

"Debra Dalgleish" wrote:

You can apply conditional formatting to pivot table values in Excel
2007. In earlier versions, you can apply conditional formatting to cells
in a pivot table, but if the layout changes, the formatting doesn't move
with the cells.

bestrugger wrote:
Can I create conditional formatting rules in a pivot table? I am trying to
create the formatting to a specific pivot field where the result is some
defined rule without having to assign it to the entire column because if I
move the pivot fields around, the conditional formatting doesn't correspond
with the original pivot field I assigned it to. Can someone help me with
this one?



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