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.
MLK wrote:
I need to add some color coding to pivot reports for variances. For example
if a variance is plus or minus 5%, then the coding is green, anything plus or
minus 10% is yellow and anything over is red. I'm trying to get conditional
formatting to work ... but no luck so far.
Any suggestions?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html