1. To add tickbox, go to Data > Data validation . Select Criteria as Checkbox Create new rows of tickboxes. 2. Once tick the event, then it should be strikethrough and the background should be grey. Go to Format > Conditional Formatting . Set values as shown below