Due dates

[Bob_lponge]

Is there a way to have a due date column which updates daily or whenever an excel sheet is opened?

For example a client has 21 days to make a return of a parcel from a specified date. Is it possible to have a column which essentially counts down these days and also turns the row amber when there are 14 days remaining to make the  return and red when there are 7 days remaining to make the return?

[#2]

@Bob_lponge Perhaps easiest to demonstrate with a working example. See attached and let me know if you can replicate the conditional formatting rules in your own file.