conditional formatting based on date

[weresmytriple]

hi all

I have a spread sheet where I need to highlight dates that are over due based on date request was sent.

the spreadsheet looks like this

A B C D
1 Date received Date Processed Manager Sign off Closed

The task needs to be processed within 28 days of being received and the manger sign off needs to be complete within 5 days of the Process being complete and the date closed needs to be within 5 days of the sign off. I need conditional formatting to highlight green when being achieved and red when the goal was missed.

does any one know a formula to enter in conditional formatting to allow this to work?

thanks

[TMS]

Date processed <= Date received + 28 = green
Date processed > Date received + 28 = red