Check out 10 Ways To Use Checkboxes In Numbers at YouTube for closed captioning and more options.
Welcome to MacMost
Free Weekly NewsletterWant all of the new tutorials in your inbox? Sign up for the free weekly newsletter that includes tips, recommendations and news.
All MacMost Shorts...
MacMost Online Courses
Connect with MacMost
- Mac Basics
- The Practical Guide To Mac Security
- Videos by Category
- Video Archive
- MacMost Online Courses
- Virus and Malware Information Center
- Protect Yourself From Online Scams
- A Graphical Guide To iCloud
- Free iPhone Ringtones
- Recommended Products
- Printable Mac Keyboard Shortcuts PDF
- macOS System Requirements List
- 10 Things You Are Missing Out On If You are Not Using the Photos App
- 7 Ways To Quickly Preview Image Files On Your Mac
- Viewing by Groups in the Mac Finder
- The Practical Guide To Mac Security: Part 5, Security Questions
- Hidden Mac Easter Eggs (2023)
- Look Out For These Online Payment System Scams
- Understanding Numbers Column References
- Different Ways To Access Files On Your Mac Desktop
Copyright © 2006-2023 CleverMedia, Inc. All Rights Reserved.
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?
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.
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.
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
Thanks, Gary...that works. Of course now I have to berate myself for not thinking of that myself.
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.