• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.



New Member
I have a checkbox that I want to control by referencing a cell, let's say cell A1. If the value of cell A1 is "Completed", I want the checkbox to be marked, if it is not "completed", I want the checkbox to stay unchecked.

How do I do that? Please help.

By default checkboxes linked to cells show either TRUE or FALSE. If you want to control checkboxes thru text/values entered in a cell, you can do that using a simple macro.

But if you just want to display checkbox value as "Completed" etc. then you can either use formulas or custom cell formatting.