This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.
Create an Interactive Checklist in Excel download file from here http://www.myelesson.org/wp-content/uploads/Interactive-Checklist-in-Excel.xlsx
Now you can create interactive checklist in excel to mark the status of tasks. This excel checklist will change color based on the status of the checklist.
A lot of people asked me
Now The 1st step is to add a check box in excel
To insert a checkbox in Excel, execute these steps: On the Developer tab, in the Controls group, click Insert, and select Check Box under Form Controls. Click in the cell where you want to insert the first checkbox
Then you would have to link the cells and do conditional formatting as shown in the video to get make interactive checklist in excel