Checklist in Excel

This example will teach you how to create checklists in Excel. First go to the tab developer (Developer) to be able to create a checklist.

1. Нажмите кнопку Insert (Insert). Then from the section Form controls (Form Controls section) select Flachill (Check Box).
2. Place a checkbox in a cell B2.
3. To remove the inscription “Flag 1”, right-click on the flag, then on the text and delete it.
4. Highlight a cell V2.
5. Hold its lower right corner and drag it down to the cell B11.
6. Right click on the first checkbox and click Object Format (Format Control).
7. Establish a connection with an adjacent cell (C2).
8. Repeat step 7 for the rest of the checkboxes.
9. To count the number of items, paste the following formula into a cell B14:

   =СЧЕТЕСЛИ(C2:C11;ИСТИНА)

   =COUNTIF(C2:C11,TRUE)

   

10. Hide a column С.
11. Paste the formula below into a cell B16:

    =ЕСЛИ(B14=B13;"Да";"НЕТ")

    =IF(B14=B13,"YES";"NO")

Result:

Note: We made the rules conditional formattingto cell background color B16 changed depending on its value.