Excel Conditional Formatting Alert Due Date?

Excel - 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

Excel Conditional Formatting Alert Due Date?
For example, go to cell C2.





Format - Conditional Formatting...





In the boxes, put the following:


1st box: Cell Value Is


2nd box: less than or equal to


3rd box: ="%26lt;=today()+60"





I hope this helps.