Conditional Formatting - Months

[LM100]

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?