Forum Discussion
Due dates
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?
1 Reply
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.
