View Single Post
  #1   Report Post  
Daniell
 
Posts: n/a
Default Pivot Table Processing

I am using a pivot table to show the amount of product that is being used in
a month. What I would like to do is color code any month that has less than
20 days usage in any month. This is part of a table that I am using:

Product Days Qty Orderld Month
1234 23 12 60 1
2345 26 90 60 1
9586 18 85 60 2
4759 21 65 60 3
2589 12 34 60 4
2589 23 56 60 5
1234 10 89 60 6
1234 23 12 60 1
2345 26 90 60 1
9586 32 85 60 2
4759 26 65 60 5
2589 08 34 60 3
2589 12 16 60 7
1234 18 72 60 8

What I want to do is list the Product by the month and if the product id
less than 10 days I would like to color code the cell.

Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Nov Dec
Product Qty Qty Qty Qty Qty Qty Qty Qty Qty Qty
Qty Qty
Product Qty Qty Qty Qty Qty Qty Qty Qty Qty Qty
Qty Qty
Product Qty Qty Qty Qty Qty Qty Qty Qty Qty Qty
Qty Qty
Product Qty Qty Qty Qty Qty Qty Qty Qty Qty Qty
Qty Qty
Product Qty Qty Qty Qty Qty Qty Qty Qty Qty Qty
Qty Qty

I know that I can use a pivot table for the QTY but I am not sure how to
color code things without showing the days?

Thanks in advance for the help.