Hi Debra ...

If pivot table conditional formatting is applied through Excel 2007, but
then the pivot table is viewed by a user on Excel 2003, will the conditional
formatting still hold for that user? Thanks ... this is a major issue for
our company as nearly all of our dashboard reports are Excel pivot tables
connected to Sql Server.

William 3

"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.

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