However, in June 2024, Microsoft introduced a much simpler way to use checkboxes.
Right-click anywhere on the ribbon, and click “Customize The Ribbon.”
Now, in the Choose Commands From field, click “Main Tabs.”
Next, tap the “Insert” arrow to expand the Insert options, and select “Controls.”
Then, to add this to the ribbon, click “Add.”
Finally, click “OK” to terminate the dialog box.
If you select more than one cell, several checkboxes will be addedone in each cell.
So, when using the IF function, these are the arguments that we will tell Excel to consider.
Remember to use quotation marks around valuesaandbif you want Excel to produce text based on the checkbox’s status.
Lucas Gouveia / How-To Geek | Kamil Zajaczkowski /Shutterstock
Now, check some of the checkboxes to see the outcomes in column C change.
This tells Excel to evaluate the checkboxes to see ifany(rather thanall) are checked.
In this example, we want the cells containing the checkboxes to turn green when they’re checked.
In our case, we want to clearly show that tasks 3 and 5 are complete.
Then, use the following steps:
Checkboxes aren’t the only way to track your task progress.
Indeed, you cancreate a whole dashboard of data in Excelto monitor your workflow at a glance.
