Conditional formatting a date in reference to another date.

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.

 

Thanks











Target Actual
05-Dec  
05-Dec  
05-Dec  
12-Dec  
12-Dec  
26-Dec  

 

 

By: chris

Leave a Reply

Your email address will not be published. Required fields are marked *