Excel 2010+Pivot Table Conditional Formatting

[wilkies0106aw]

All,


Struggling to figure this one out.


I have a pivot table with a column label which is a date field (assignment finish date). My values are a count of the assignement finished date. i.e. How many assignments were finished on day X?


I need to conditional format my value field counts to show all documents which were completed after a specific date i.e. 31/03/2012.


Assignments can finished on 1 day and completed on another. The pivot table doesn't show the completed date as a column label.


I'd like to add a second condition formatting rule which shows all documents which were finished before 31/03/2013 but have not been completed before 30/04/2012.


Any ideas?

 

[jason]

the easiest option i can think of without seeing a sample (can one be uploaded) would be to add the completed date field for each assignment and then add the conditional formatting to that field.