Hello,

What i am looking to do is add some formatting to rows dependent on the current date.

when a date is up for renewal i would like it to highlight the row 7 weeks in advance (perhaps orange) and then change again the fill colour again to Red once the date has expired.

attached is an example sheet.

Thanks in advance.

Book1.xlsx