Checkbox if 2 cells are equal
If the value in C2 is the same as E2 I would like the checkbox in F2 to be checked.
Seems so simple but I can't figure out how to do it.
Mac mini (M4 Pro, 2024)
Question marked as
Yes and no. It depends on what you are expecting. A checkbox is meant to be for user data entry where the user checks or unchecks it. It is possible, though, to make a checkbox that checks/unchecks itself via a formula. In this case, it will no longer accept user entry, it will be controlled by the formula. It will become a visual display of a TRUE/FALSE result that happens to look like a checkbox.
Here's how you make a self-checking checkbox:
- Format cell F2 as a checkbox
- With F2 still selected, go up on the menu and click on Insert->Formula->Edit Formula
- In F2 put the formula C2=E2 .
When C2 is the same as E2 the result will be TRUE and the checkbox will check itself, otherwise it is FALSE and the checkbox will be unchecked.