View Single Post
  #1   Report Post  
revm2
 
Posts: n/a
Default Pivot Table row comparison

I'm trying to compare an old customer schedule with their new schedule
and highlight the changes with colour or by hiding a row. My pivot
table looks like this

Prod Sched wk1 wk2 wk3
A old 3 2 3
A new 3 4 3
B old 2 2 2
B new 2 2 2

So in the above example I'd like to colour the cells for wk2- Product A
in yellow, and hide the product B rows as there has been no change in
demand.

Can someone give me some advice about how to do this
Thanks for your help
Ross