Microsoft Excel - Reverse Checkboxes (A different use for the upcoming Modern Checkbox feature)

Learn how you can use a formula to change the state of the new Modern Checkboxes. This is great for displaying the status of an item, task, or event.

File Download Link:

Video for "New Modern Checkboxes" demonstration:

[jerrydellasala]

I set the font color of the checkbox to red, and then using simple conditional formatting for cells equal to "=TRUE" set the font color to green bold. Works like a charm! Nice, short, clear video.

[DingusBatus]

I was slow to catch on to the names there. Funny play on words.🤪
I’m still waiting on the feature, and the update in general, to actually be released.
Not sure what I would use it for but I would certainly play around with it, chances are I might have come up with this on my own?
Thanks for the video.😀

[youstes]

Nice one boss, do you have any idea when the new checkbox will come out ?

[sridharramadurai]

I used this 2-3 months back. My check box ticked itself when a student completed his instalment payment. Basically it checks the balance column and when that turns zero, the checkbox ticks itself.. I used it for fun as there was no value addition in my situation. It was to learn how the checkbox works and I found it interesting.

[kevindailey]

I Love the list of names!!! Whenever I am doing a play on words with names I like to add a middle name i.e. Helena Bonham Handbasket

[Paladin]

This has been in beta for such a long time and I’ve been working around not having it in a number of pieces of work I’m doing. Does anyone have an idea why it’s taking so long to release it?

[rashah]

Hi, How can automatically click checkbox in entire raw with the colour (Blue for High & Red for Low Touch) when (( B1 is equal to C1 (High) (B1=C1)) or (( B1 is Equal to D1(Low) (B1=D1)) in first time and then I manually remove checkbox colour will disappear I AM IN STOCK MARKET SO WHEN CURRENT PRICE COME TO DAYS HIGH OR LOW SO I CAN easily FIND OUT FROM LIST thanks

[ianl]

Ben Dover?!? Really?!?🤣 You have a wicked sense of humour when it comes to name creation my friend. Here's a tip for you if you want a quick way to create lots of random names for larger file examples. Just google 1000 random names. There's a site with that name. Just copy and paste them all and use them as you want in Excel and Access.

As for your video... Short and painless. Easy to follow. The reverse function itself is cool. Excel just keeps getting better. Despite discovering Leila's channel first, I'll still check out your Checkbox video, if only to compare your different styles.