Enhance Your Checkboxes & To-do Lists with Conditional Formatting in ExcelVevo Digital
In this video, I demonstrate how to improve your Excel checklists by using conditional formatting. When a box is checked, you can gray out or strikethrough the text and even highlight the next task on the list.
This technique uses the Form Control Checkboxes and conditional formatting. The video is packed with additional tips for creating and working with checkboxes on sheets, enabling the Developer tab in the Ribbon, setting the cell link for a checkbox, writing formulas for conditional formatting, and more.