Hi.
I'm trying to conditionally format 2 cells in a row based on when an ARP is due.
The data I'm working with looks a bit like:
Name A September 09
Name B December 08
Name C November 08
Name D Feb 09
Name E Jan 09
This data really has 01/09/09, 01/12/08 but the cell is formatted to show just month and year
I want 5 conditions:- Overdue by more than 3 months
- Overdue by between 3 and 1 month
- Due this month
- Due next month
- Due between next month and 3 months time
- Due in more than 3 months
Can this be done? I'm told I can only have 3 conditions.
Also, I'm not sure how I'd select the Name to be formated as well as the month.
I was thinking of doing a list somewhere with
-3 Months October 2008
-2 Months November 2008
Last Month December 2008
This Month January 2009
End Of Next Month February 2009
+2 Months October 2008
+3 Months November 2008
This data also really has 01/09/09, 01/12/08 but the cell is formatted to show just month and year
......And then comparing data ranges.
Could anyone draw up some VBA for me for one row so as I may duplicate?
Bookmarks