10 Ways To Use Checkboxes In Numbers

Checkboxes are a useful tool in Numbers that allow you to simply indicate a true or false value. You can use that as data, to sort, filter or alter the outcome of formulas.

Comments: 8 Responses to “10 Ways To Use Checkboxes In Numbers”

    harry
    8 months ago

    Gary , is there a way to prevent user from checking a box if the previous check box is not checked. in your example you could not check received if one of the prior boxes is not checked?

    8 months ago

    Harry: No. There is no way to do that. For one thing, there is no distinction between a "user" and someone more powerful than a "user" when it comes to a Numbers document.
    What you can do though is have a cell that uses an IF function to display a noticeable error message when things aren't being done right.

    Jimmy Marchini
    8 months ago

    Is there a way to use conditional formatting for a cell related to its corresponding checkbox cell. For example... in the table you use in this video... is there a way by clicking the checkbox in cell E3 it will conditionally change the format color of the font in cell D3 ($300).... or perhaps change the color of the D3 cell itself, or even both.

    8 months ago

    Jimmy: You can do that if you have F3 using an IF function to set it to the value of D3 if E3 is checked. Then the conditional highlighting for D3 has the criteria that it should be highlighted if D3 has the same value as F3. Then hide column F if you like. https://macmost.com/numbers-conditional-highlighting-based-on-other-cell-values.html

    Jimmy Marchini
    8 months ago

    Thanks, Gary...that works. Of course now I have to berate myself for not thinking of that myself.

    John
    8 months ago

    Gary, thanks. This was really good information. I use Numbers often but I donā€™t look into the details often enough. Numbers is actually quite awesome.

    Mik
    4 months ago

    Hey, is there a way to show checked boxes? Right now, they just dissapear. I'd like them to appear at the bottom of the list. Thanks Gary for explaining things so well!

    4 months ago

    Mik: Not sure what you are dealing with. They shouldn't disappear. Not sure what you mean by "appear at the bottom of the list" at all.

Leave a New Comment Related to "10 Ways To Use Checkboxes In Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)