How do you conditionally format highlighting a due dates?

[Marjo101]

I have -
Column A - Team Leaders names
Column B - New staffs names
Column C - What the reminder is - Supervision, 1st Performance Management, 2nd
Performance Management and Final performance Mangement
Column D - The date when the reminders in Column C have got to be completed by.

At the top of the page I also have the current date which automatically updates daily.

I would like to 'Conditionally Format' Column D to turn yellow when the current date is 28 days before each due date, turn orange when 14 days before each due date and turn red on or past each due date.

Can anyone help?

[Bob Phillips]

See http://www.xldynamic.com/source/xld.CF.html#due

[Marjo101]

Your a star and very quick. Thank you very much
Yours
Jo

[Marjo101]

Since adding the 'Conditional Format' sent by Bob Phillips I have added another column 'Completed' so that if a meeting has been completed the date goes into this column.

How to I stop the 'Conditional Formatting' from actioning if there is a date entered into this new column?

[Marjo101]

I have 'Conditionally Formating' on a Column to turn yellow when the current date is 28 days before each due date, turn orange when 14 days before each due date and turn red on or past each due date.

I have added another column so that when meetings have been completed, the date is entered.

How do I stop the 'Conditional formating' from actioning when a date has been put in the completed column?

Can anyone help?