Conditional Formatting

[Dale]

In cell A1 i input todays date eg 01/01/07
In B1 it automatically adds 14 days to A1 date to produce a Due Date
15/01/07
In C1 i have a field called task completed with a result of Y or N or
blank cell
I want 2 layers of Conditional Formating
i. Upto 4 days the date in B1 11/01/07 12/01/07 13/01/07 or 14/01/07
and C1 is blank i want the B1 date to turn blue
ii.If on or after 15/01/07 C1 is blank i want the B1 date to turn red
iii. If C1 has a N in the fiels i want A1-C1 to turn grey nothing
happen to B1
iiii. If C1 has a Y A1-C1 shade green and nothing happen to B1

Hope this makes sense