Channel: Excel Campus - Jon

Category: Education

Tags: excelcheckboxesusing checkboxes to link to a cellexcel campusinteractive checklistcheckbox controlconditional formatting in excelhow to make excel checkboxesmaking checkboxes in excelusing excel check boxes

Description: 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. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/tips/checkbox-conditional-formatting Related Videos: Conditional Formatting Rows Based on Another Cell Value: youtube.com/watch?v=YAzK9vHa178&t=201s Highlight Rows Between Two Dates with Conditional Formatting in Excel: youtube.com/watch?v=-dX-njUhiMU&t=43s How to Apply Conditional Formatting to Pivot Tables: youtube.com/watch?v=WwAV0gsJa0c&list=PLKbOx3gUV_E86g1Qj6Qz-9LYzQZrQ-EIl&index=3 Shortcut to Duplicate Shapes with Ctrl+Shift+Drag: excelcampus.com/charts/copy-align-charts-shapes #MsExcel #ExcelCampus