Here's my situation

I have 3 colums

1. Last completed
2. 6 month expiration
3. 12 month expiration

Both the 6 month and 12 month colums have grace periods of date +1
month

The +1 month would be end of month, so if the expiration date is
08/20/2007 the grace period would be valid until 09/30/2007

I would like excel to change the text color to Blue if the current
date is beyond the expiration date but within the grace period.

I would like excel to change the text color to Red if the current date
is beyond the grace period

I currently have it set to change the color using conditional
formating if it is beyond the current date =AND(D3<"",TODAY()-D30)

But i do not know how to set it up to change the color if the current
date is within the grace period and change it to a different color if
the current date is beyond the grace period.

any help would be appreciated.

Jeff