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.
Thanks!