Interactive Checklist in Excel (Auto-highlight completed tasks ✔️)
Interactive checklist in Excel that auto-highlights completed tasks and keeps a tally of the total tasks completed.
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
⚡ DOWNLOAD the '40 Incredible Excel Tips' book - https://bit.ly/40ExcelTips
The new checkboxes in Excel 365 are fantastic. They make creating a checklist in Excel like this, super easy.
The Conditional Formatting rule is simple (knowledge of cell referencing helps), and the formula to sum completed tasks is a little more fun.
#excel #exceltricks #excelshorts
