00:00By utilizing a progress bar and a checkbox, you can develop a task tracking tool in the following
00:05way. First of all, let's introduce a checkbox here. Let's click on C4 and go to developer tab.
00:11If this developer tab is not available, you can make it visible by going right click anywhere on
00:15the ribbon here. Customize the ribbon and make sure that the check on the developer is turned
00:21on like this. Once that's done, this will be visible. Click on insert form control and there's
00:27a checkbox there. We don't want active X, we're going to use form control. Click on it and place
00:32the checkbox somewhere near C4 like this. Then reposition it nicely so it's somewhere in the
00:39middle of cell C4 and right click on it, edit text and press delete on your keyboard a few times so
00:45that you can get rid of the text next to the next to the checkbox here. And after that, click on
00:50anywhere on the cell and the description next to the checkbox is gone. Now you have to associate this
00:56checkbox to the cell C4. Right click on the checkbox here like this and from the context menu, you're
01:02going to select format control. In here, you want to click on the controls tab and on the cell link,
01:09you click on it, you're going to click on C4 like this and it should come up like that and click OK.
01:16Now what you did with that cell link is that when you click on this, you can see the true and false
01:21populating on cell C4 but we don't want to see the the the text true and false I guess so you're
01:29going to have to change the font color to white. Go to home font and then click on white here and it's
01:34gone. When you click on it, those text doesn't appear. Now you're going to have to propagate the
01:39characteristic of C4 all the way down to C13 this way. Click on it and drag it. But there's one thing you
01:47haven't done yet. You can right click on this guy and go format control. You can see that every one
01:53of the checkbox is still associated with C4. When you click on this guy, you can see everything goes
01:58turned on and off. So you got to make it individual. Right click on the checkbox format control and then
02:04you go controls and in cell link, you're going to have to select each individual cell like this.
02:11I'm going to fast forward here.
02:28Once the checkbox are ready, let's click on B2 to add the progress bar. Enter the following formula
02:36and you can see it comes up with number one. So if you
02:39remove the checkbox, you can see that it goes in fraction. Let's change this into percentage by
02:43holding ctrl shift percent. Now it shows in percentage. So you're going to click on this guy here. Go
02:51formatting, data bar and then after that, you've got more rules. In here, you're going to change the
02:57minimum to number and the maximum to number and make sure that the minimum is zero to indicate false
03:05and the maximum is one to indicate true. I'm going to make this into a gradient field. So it's nice
03:11looking gradient and you can select any color you want
03:17and then click OK. And you can now see the progress bar. So if you remove the checkbox,
03:22you can see that the progress bar changes accordingly. And if you add more checkbox,
03:27the progress bar changes accordingly as well.
Comments