Hi guys, been looking around the forum to see if this has been brought up before with any luck.

I need to have conditional formating placed on column that gives automated dates. It needs to show overdue dates from today (RED), dates that are due today (Yellow). I also need completed dates (green) and this is based on information from the adjacent row.

I think I have the forumula for the RED and YELLOW formatting but the forumula for highlighting cells GREEN is really confusing as it based on the adjacent cell.

I have attached a spreadsheet that should show what i am looking for and I am using Excel 2007

Any questions please let me know. All help is much appreciated

test.xlsx