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
Bookmarks