|Thanks for your response. I was trying to add an additional column because every conditional formatting option I have tried does not work within the pivot table. However if I can work within the table, this would be preferable. I have even considered going back to the Access database and trying to bundle the dates together, but I'm relatively new at Pivot Tables and Access.|
My columns are as such:
Column L = P1, P2 or P3 (Stands for Priority type)
Column M = Used a formula to turn column L into numerical value such as P1 = 3, P2 = 7, P3 = 14 (number represents days)
Column N = Date 1 - Date Project is presented
Column O = Date 2 - Date of Completion
I want to conditionally format either one cell or the entire row if Date 2 (O) - Date 1 (N), is greater than Column M's different numerical values corresponding with their priority.
Ultimately I want to show when we have surpassed our deadline to complete a project based on it's priority. For example, If I have a project that is P1 (L), which represents in 3 days due (M), the difference between my completion date (O) and my start date (N) should not be greater than 3 days (M).
I have tried to conditionally format with the formula as described above, but it has not worked. Do I need to select the data in a particular way?
PRICING_PRIORITY P1-4 IN DAYS PRICE_EFFECTIVE_DT PRICING_COMPLETED_DT
P3 14 7/13/2012 7/23/2012 16:53
P1 3 11/29/2012 11/30/2012 13:32
P3 14 8/15/2012 8/17/2012 15:43
P2 7 7/27/2012 8/8/2012 13:06
P3 14 10/9/2012 10/23/2012 13:38
P3 14 9/24/2012 9/27/2012 14:18