Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |