- You must enable macros for the sort function to work
- Enter priority between 1 and 3 for conditional colour formatting to work
- Enter completion date to automatically change the status from ‘To-Do’ to ‘Done’
This Microsoft Excel To-Do List and task tracking template has been developed on construction projects. It is formatted with conditional colouring and an automatic sort button. The programmed sort function helps you to prioritise your tasks by considering priority and due dates. This template is unlocked and can be customised to suit. You can add or delete columns as required. It can be used as a personal to do list or to track the progress of an entire team. The status update allows you to track progress which is in particular important for tasks that extent over a longer period of time.