Conditional Checkbox in Google sheet

Loading

Requirement: Formatting each completed task using conditional checkbox in Google sheet

Create a google sheet, Click on Format tab, Select Conditional formatting, Then add the cell by selecting them, now select custom formula add formula to that and select striker formatting style.

Apply to range - select the complete table (A2: C11) then Format rules:
Custom formula is  =$C2

It is used for formatting striker style for completed tasks in cells using conditional checkbox. when the user clicks on check it means the task is completed it display as striker format style.

Leave a Reply

Your email address will not be published. Required fields are marked *