3 Impressive Dynamic Reports using Check Boxes

How to create interactive check boxes in Excel, which can be linked to formulas, charts, conditional formatting and other features. Check boxes can be a great way to make your spreadsheets more visually appealing, user-friendly and efficient, allowing users to quickly select options and see the results of their selections in real-time. We'll walk you through the process step-by-step.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 Interactive Excel Reports with Check Boxes
0:48 Check Box Task List
3:02 Status Bar Linked to Task List
4:48 IF formula linked to Check Box
6:37 Conditonal Formatting linked to Check Boxes
9:58 Charts Linked to Check Boxes

[IvanCortinas_ES]

I love the graphic with the selectors depending on the activation of the CheckBoxes. Thank you Mynda. As always, a video with a lot of practical information.

[brighttriangle]

I love using the check box to turn conditional formatting on and off. Great example. Thank you for sharing.

[aiasaiascon]

Really Cool !!! especially the Coercion - - and the IF "boosting language"!!! Really nice boost from a Really Successful Mother😇

[remuslupinhp]

it blew my mind, how you can utilize a small feature and expand it to do great things...super cool applications..

[kama]

Fantastic video as usual… I had never thought that Excel might become the key to the survival of my kid’s Guinea pigs … 😅 I love this solution, and also the other two… amazing Mynda!

[roywilson]

Nice video! The old tricks are always the best :)

[jimfitch]

Another great tutorial, Mynda. Thank you. Would you please explain the differences between and different use cases for Form Controls & ActiveX Controls? (Perhaps as a separate tutorial?)

[SpotlightImpact]

Holy moly! This is awesome! Love the nested IFs to give the different alert text strings! Very cool! Thanks as always Mynda! 🥰🥰

[FredericLEGUEN-Excel]

Hi Mynda, very useful (as usual) and very good use of the checkboxes. You can simplify your formula to stripped the color of the rows with =MOD(ROW(), 2)

[alexanderbaranov]

Thanks you, professor Mynda, for new ideas!)

[rehanshah]

I believe one reason why check boxes in excel aren't used frequently is because we have to link each of them to specific cell one by one. But, there is one mind blowing trick with form controls that allows user to overwrite in cell based on multiple cells/inputs (basically dual supervisor cells/inputs on single cell:
Step 1: Use have to allow circular referencing on the sheet.
Step 2: Add 2 or more form control buttons (I used up-down) and reference them to same cell.
Step 3: Now, when you change values using any of the buttons, it will change the value of the cell.
Use case: When we want to change the core theme/scenario of an excel model, let's say there are different scenarios like Normal, Good, Bad and calculation are based on the selected scenario, and you want to change the scenario from any sheet of the model, one can make these buttons on each sheet to change values accordingly.

[HandelMcHandel]

Fantastic Mynda - now all you need to do is teach Diego to use Excel!

[anthonygikuri]

I wish I were this little son of yours. By age 10, I'd be a professor of Excel. What an opportunity this son to have a mommy like you😂

[Chef-]

Another really really helpful tutorial. I really appreciate all your videos and very often can inspire a direction of travel for my dept that I had not thought available so often able to implement more productive way of working. Your videos are a fabulous resource for learning and inspiration. ( bonus is you are also beautiful )

[aureliensimon]

Thank you so much Lynda, Great video !

[questionmark]

Hi Mynda,
Thank you for another fantastic training video; you are certainly my Excel MVP and I appreciate your efforts.

Question: in the banded rows topic, why did you not opt for using ROW() minus row of the fixed header to fund the row?

Cheers,
Mark

[zahoorsarbandi]

another great lecture. Thank you very much.

[zaurmissikov]

I take off my non-Australian hat! Incredible as always!

[nadermounir]

Very nice video, thabk u for sharing this with us 😊

[cedjulemckeever]

As usual, a great training video. Also, great to see that a boy has to wear a tie to school.