I have the task of conditionally formatting a date in a cell in refernece to another date. What I need is that when a date is intered in the blank cell if that date falls before the target date the cell is green, if the date is within 7 days of the target date it is orange, if the date is after the target date it is red.
The below table is an example of what the problem is around. One column for the target date. One column for the actual date which is to be entered upon completion of work.