View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MLK MLK is offline
external usenet poster
 
Posts: 81
Default Conditional formatting in pivot tables?

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?