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