Skip to content

Add A Strikethrough to Completed Tasks

In this article, I will show you how to add a strikethrough to completed tasks in Google Sheets.

Once you have everything set up, all you have to do is click a checkbox for each task to mark it as complete and also add a strikethrough effect.

The Initial Setup

Before going any further, here is the initial setup you want for your tasks in Google Sheets.

Add “Task” to cell A1, and “Done” to cell B1. I also recommend adding a light fill color to distinguish the column headers in A1 and B1 from the rest of the worksheet.

Once you have this initial setup complete, you are ready for the next step.

Add the Checkboxes

With your column headers in place, the next thing you need to do is add checkboxes to the cells in the Done column.

To do this, select the cells that will designate the “done” status for each task, and then go to Insert Checkbox.

With your checkboxes in place, you are ready for the final step.

Add Conditional Formatting

For the last step, you need to add conditional formatting to all of the cells that will contain the task descriptions.

To do this, select the range of cells that will contain the listed tasks.

With these cells selected, go to Format Conditional Formatting.

In the Conditional format rules panel on the right, click on + Add another rule.

Under Format cells if, select Custom formula is.

For the formula, enter =$B2.

Then, under Formatting Style, set the fill color to None, and click the Strikethrough button. Finally, click on Done.

Now, whenever you mark one of the tasks complete using the checkboxes, a strikethrough will be placed over the completed task.

See It In Action

Check out the video below to see this whole process from start to finish!

This Post Has 2 Comments

  1. This is so great! I have a question though: how does the formula for the conditional formatting work? Why does putting the formula as “=$B2” indicate that the check box has been checked?

    1. That’s a great question! Let’s break the formula down.

      The $B part of the formula indicates the conditional formatting to check the value in column B. The 2 part of the formula is the confusing part. Since the top row of our selected range (that we want to apply conditional formatting to) is in row 2, we put a 2 in this part of the formula. Plus, since there is no dollar sign ($), this part of the formula will change for each cell in our selected range. For instance, cell A3 will consider the value in cell B3, A4 will consider B4, etc. Notice how the column letter (B) is staying the same while the row number is updating.

      I hope this makes sense. If you need me to clarify anything, please let me know.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top