We selected a grey font color and strikethrough font type to express completed items.

Click the Format button to open Format Cells.

TRUE tells Excel to apply the determined format. This formula allows you to format unchecked items, because FALSE will become TRUE thanks to the NOT function. Be sure to leave the row part relative: =NOT($D5) (Relative reference is important to let Excel copy the formula to other cells in the column). Enter a formula which is using the NOT function with the reference of the first cell of the Helper.Select Use a formula to determine … item in New Formatting Rule.Open the New Formatting Rule window by following Home > Conditional Formatting > New Rule.Select all of to-do items in your list.Adding conditional formattingĬonditional formatting is great way to help distinguish completed and not-completed items. Now, let's take a look on further customization options for our To-Do list. You will see that cells in the Helper column show either TRUE or FALSE value based on the checkbox selection. Once linked, check and uncheck the checkboxes to make sure they are linked correctly. Once the checkboxes are ready, link them to adjacent cells under the Helper column. See how to insert a checkbox in Excel for more details on how to add checkbox controls. You can add multiple checkboxes by creating one inside a cell and dragging it down for the rest.

Helper column for storing the values of checkboxesĬheckbox controls can go under the status column.

Start by creating a 3-column range for the to-do list. In this guide, we’re going to show you how to create a To-Do list in Excel with the help of checkbox controls and conditional formatting.ĭownload Workbook Preparation before creating a To-Do list

Todo list excel