How about an alternative???

Your raw data looks kind of like this:

Prod Sched wk# qty

I'd insert a new helper quantity:

Prod Sched wk# qty AdjQty

Under that adjqty, you'd have a formula like:

=if(c2="new",d2,-d2)

(negative numbers if the schedule was old)

Then create a pivottable that just shows the difference.

Prod Wk1 wk2
A 3 0
B -5 5
....

What do you think?

revm2 wrote:

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

--

Dave Peterson