This is definitely not possible using formulas.
You would have to use VBA to get that to happen.
Alternatively, you could have other ways for users to mark their options. An in-cell dropdown, or option buttons will do the trick without having to resort to VBA.

Don't forget to click the little star to the left of this post if you feel I helped!