Conditional Formatting Alert Due Date?

Heading in cell C1 POS Notification Date -- Cell C2 4/9/2007 (I need for this dated to go to red 60 days prior to the date shown.)





Heading in cell D1- POS Interview Date -- Cell D2 4/23/07 (I need this cell to turn green 7 days prior to date.)





Heading in cell E1 - POS Report Date -- Cell E2 5/1/2007 (I need the cell to turn blue 7 days prior to date)





Thank You

Conditional Formatting Alert Due Date?
In what language?

teething