Sign up for our Excel webinar, times added weekly: [ Ссылка ]
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: [ Ссылка ]
Related Videos:
Conditional Formatting Rows Based on Another Cell Value: [ Ссылка ]
Highlight Rows Between Two Dates with Conditional Formatting in Excel: [ Ссылка ]
How to Apply Conditional Formatting to Pivot Tables:
[ Ссылка ]
Shortcut to Duplicate Shapes with Ctrl+Shift+Drag:
[ Ссылка ]
#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
