How to Add Strikethrough When Checkbox is Checked in Google Sheets

To add a strikethrough when a checkbox is checked in Google Sheets, you can use conditional formatting. Here are the steps to set it up:

1. Open your Google Sheet and select the cells where you want to apply the strikethrough effect when the corresponding checkbox is checked.
2. Click on the 'Format' menu in the top toolbar, then select 'Conditional formatting' from the dropdown menu.
3. In the 'Conditional format rules' sidebar that appears on the right, click on the 'Format cells if...' dropdown and select 'Custom formula is.'
4. Assuming your checkboxes are in column A and the cells you want to apply the strikethrough effect to are in column B, enter the following formula in the 'Value or formula' field: = $A1 = TRUE

Make sure to adjust the formula if your checkboxes are in a different column or the cells you want to apply the strikethrough effect to are in a different column.

5. Click on the 'Formatting style' dropdown and choose 'Custom.'
6. Check the 'Strikethrough' box and adjust any other formatting options as desired.
7. Click on 'Done' to apply the conditional formatting rule.

Example

Suppose you have a to-do list in your Google Sheet, with checkboxes in column A and task descriptions in column B. Here's how you can set up a strikethrough effect for the task descriptions when their corresponding checkboxes are checked:

1. Select cells B1:B20 (or the range where your task descriptions are located).
2. Click on 'Format' > 'Conditional formatting.'
3. In the 'Conditional format rules' sidebar, select 'Custom formula is' from the 'Format cells if...' dropdown.
4. Enter the formula = $A1 = TRUE in the 'Value or formula' field.
5. Choose 'Custom' from the 'Formatting style' dropdown and check the 'Strikethrough' box.
6. Click 'Done' to apply the conditional formatting rule.

Now, when you check a checkbox in column A, the corresponding task description in column B will have a strikethrough effect applied to it, indicating that the task is completed.