Conditional Formatting

[solberg2004]

Hi all



I am having trouble trying to set up conditional formatting on a spreadsheet.

A description of the layout is as follows:

Cell A1: Date invoice issued for Approval
Cell B1: Approved Invoice Return Due Date
Cell C1: Approved Invoice Actual Return Date

Cell A2: 09/01/2017
Cell B2: 16/01/2017
Cell C2: Blank


When an invoice goes for approval it must be approved within 7 days.

Point 1: I want to set up a formula that when the invoice date for approval is entered (Cell A2) the return due date automatically comes up (Cell B2).

Point 2: If an invoice is not returned by the due date I want excel to automatically flag this cell a RED colour after the 7 days has elasped.

Point 3: If the approved invoice comes back after the 7 days, the cell has already flagged up red, but when the actual return date is manually entered I want Cell B2 to go ORANGE.

Point 4:If the approved invoice comes back before the 7 days Cell B2 shall remain GREEN as it is within the 7 day timeframe.

Any help in inputting these conditional formats and formulas would be greatly appreciated.