Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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: https://www.excelcampus.com/tips/checkbox-conditional-formatting

Related Videos:
Conditional Formatting Rows Based on Another Cell Value: https://www.youtube.com/watch?v=YAzK9vHa178&t=201s

Highlight Rows Between Two Dates with Conditional Formatting in Excel: https://www.youtube.com/watch?v=-dX-njUhiMU&t=43s

How to Apply Conditional Formatting to Pivot Tables:
https://www.youtube.com/watch?v=WwAV0gsJa0c&list=PLKbOx3gUV_E86g1Qj6Qz-9LYzQZrQ-EIl&index=3

Shortcut to Duplicate Shapes with Ctrl+Shift+Drag:
https://www.excelcampus.com/charts/copy-align-charts-shapes/


#MsExcel #ExcelCampus
00:00 Introduction
00:12 Enhance Checkboxes with Conditional Formatting
01:43 Inserting a Checkbox
04:00 Linking the Checkbox
04:51 Applying Conditional Formatting