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?

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

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