I have a client spreadsheet and I am trying conditionally format the cells to highlight in different colours based on the number of days that have passed since the “Date of Last Contact”. 

Green: 0-3 days

Yellow: 4-9 days
Red: 10 days+

The formatting needs to correspond with the date in column J and most online tutorials use the =TODAY() function which does not quite suit my needs. 

Can anybody please help me? 

​I have a client spreadsheet and I am trying conditionally format the cells to highlight in different colours based on the number of days that have passed since the “Date of Last Contact”.  Green: 0-3 daysYellow: 4-9 daysRed: 10 days+ The formatting needs to correspond with the date in column J and most online tutorials use the =TODAY() function which does not quite suit my needs. Can anybody please help me?   Read More

​