LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
pivot table created from another pivot table Kreed Excel Worksheet Functions 6 October 26th 05 04:16 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"