16.2 C
London
Thursday, July 24, 2025
HomeSoftware TutorialsGoogle SheetsGoogle Sheets: Add Strikethrough When Checkbox is Checked

Google Sheets: Add Strikethrough When Checkbox is Checked

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

You can use the custom formula function in Google Sheets to add a strikethrough to specific cells when a checkbox is checked.

The following example shows how to use the custom formula function in practice.

Example: Conditional Formatting Based on Checkbox

Suppose we have the following list of basketball team names in Google Sheets:

Now suppose we know that the following teams have been eliminated from the playoffs:

  • Mavs
  • Warriors
  • Hawks
  • Suns

Suppose we’d like to create a checkbox that, when checked, each of the teams that have been eliminated will have a strikethrough applied to their team name.

To do so, we need to first insert a checkbox by selecting cell C2, then clicking the Insert tab, then clicking Checkbox.

The following checkbox will appear:

Next, click cell A2, then click the Format tab, then click Conditional formatting:

In the Conditional format rules panel that appears on the right side of the screen, type the following cells in the box called Apply to range:

A2,A5,A7,A10

Then click the Format cells if dropdown, then choose Custom formula is, then type in the following formula:

=C$2=TRUE

Note: It’s important that you include the equal sign (=) at the beginning of the formula, otherwise the conditional formatting won’t work.

Then, in the Formatting style box, click the icon that has a strikethrough symbol (to the right of the underline symbol).

Lastly, click Done.

Now when you check the checkbox in cell C2, a strikethrough will be applied to each team that has been eliminated from the playoffs:

Google Sheets checkbox strikethrough

Each of the teams that have been eliminated from the playoffs now have a strikethrough applied to their team name.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Sum If Checkbox is Checked
Google Sheets: Conditional Formatting with Multiple Conditions
Google Sheets: Conditional Formatting if Another Cell Contains Text

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories