How to Highlight a Cell or Row with a Checkbox in Excel | SKYXCEL

Welcome to SKYXCEL Tips & Tricks! Today we will be showing you how to highlight a cell or row based on if a checkbox is clicked or not. Combing user form controls and conditional formatting is a great start for creating more interactive and dynamic Excel spreadsheets.

Please give this video a like if you found this tutorial helpful and subscribe to receive updates for future tutorial videos that will save you time and increase your efficiency.

We invite you to leave any questions or request in the comments below!

In need of more Excel assistance specifically for you? Visit

[factreal]

Buddy you are great person, I was searching for this for a long time, finally some dude explained me verywell. thank you.

[CAshcroft]

THANK YOU! I could not find anyone else with a tutorial to this.

[markdonovan]

If have 250 checkboxes, is there a quick way to format the control or do I have to each one manually?

[romanperez]

Thank you...this tutorials such a big help for starters

Thank you very much for the explanation.
It was very clear, calmly spoken and excellent explanation.

[sparkie]

Excellent, Very Complete and Well done.

[nelumwarsakoon]

Very useful for Bank reconciliations. Thanks a lot…!

[jawadhindi]

Thank you. Can I use orange as an option in addition to green and red?

[elijahd.spragueph.d]

Great Video! Is there a way to connect all check boxes to their individual rows without doing it one by one?

[mehappym]

great video. wondering if its possible to keep the cell locked and only able to tick if the cell above is ticked. So a step by step process. 1st box gets ticked, so seconds gets unlocked but third remains locked. When second is ticked 3rd box gets unlocked. And so on. Is that possible at all ?

[narutoroxanne]

So, if i want to "Format Control", I have to do it to each cell individually in a list of 500+ entries?

[BarryJHoffman]

Great video! my check boxes are so small (Mac excel) can't hey be made bigger? thanks!

[ShahanPeekays]

hi, i need to link to 1000 entries. As per your comments, you mentioned it can be done via VBA. could you please create a new video on it showing how it can be done in VBA?
thanks a lot for the video.

[jh]

wow. I would never have gotten that on my own...

[MA]

I have a worksheet with the following data, , , vendors name in Column A2, Paymnt Amount in Column B2. Check-boxes in Column C2, Paid/Unpaid text in Column D2.
I would like to establish a link between check-boxes and the 'amount' column. Specifically, I want the checkbox in column C2 to be automatically checked when I enter an amount in cell B2. Additionally, when the checkbox is automatically marked as checked, I would like the text 'Paid' to appear in column D2. Is it possible to achieve this using a formula or VBA/Macro?

[generationsarising]

I am looking for a way to format some dependent tasks if the trigger is checked done. Is there a way to do that in excel?

[aixazerpa]

Is it possible to increase the size of the check box??

[Catv]

My Default check box is way to small for what I want. How can I resize the Check Box itself? I'm not talking about the selection bounding box around it. Can I change the default size or resize after I have put it in the form? Nothing I try seems to work to resize the check box. Definitely not very intuitive.

[ElizabethObuks]

How do you move the box to the exact centre of the cell?

[XNeoxx]

How can you resize the checkbox like this, i tried everything but it wont work