If the due date is today, a yellow warning icon is shown.

If the due date is earlier than today's date, the conditional formatting condition will make the date red and display a red dot icon. If you don't need this column, just delete it.ĭue Date: Enter values in date format. See the PICK Chart page for more information about this useful lean six sigma technique.

PICK: This is an acronym that stands for Possible, Implement, Challenge, or Kill. Currently, the Priority column uses conditional formatting to highlight 'High' red and 'Low' blue. Priority: You might want to use a 3-, 5-, or 10-point numeric scale for this column, where 1 is the highest priority. You might also use this column to enter the percentage complete such as '50%' or '75%.' Note: If you change 'Completed' to something else, you may also want to edit the conditional formatting rule in the table. Status: You can enter values such as 'Completed' or 'In Progress' or abbreviations that you define yourself. You can customize the items shown in those columns of the To Do List by editing the values in the Lists or Ref worksheet. In version 1.1.0, I added a few dynamic ranges that are used to populate the customizable drop down lists used for the Status and Priority columns. To edit the conditional formatting rules in this worksheet, go to Home > Conditional Formatting > Manage Rules and select 'This Worksheet' from the drop-down. You can also delete one or more of the columns if you do not need it. The Vertex42™ To Do List template allows you the flexibility to use whatever codes, scales, or abbreviations you want for each of the columns.

Todolist template