Cross Out a Row When a Checkbox Is Checked in Google Sheets

A to-do list in Google Sheets looks much better when finished tasks are crossed out. You don’t need a script: a conditional formatting rule can apply strikethrough to the whole row as soon as its checkbox is ticked, and remove it when you untick it.

Tested in Google Sheets. On November 11, 2026 we set up the rule below on a five-task list with two boxes ticked and checked the result in the sheet. How we test

The rule

Our list had the task name in column A, a checkbox in column B and three more columns (due date, amount and status). The data started in row 2.

  1. Select the task rows without the header, for example A2:E100.
  2. Open Format > Conditional formatting and choose Custom formula is.
  3. Enter this formula:
    =$B2
  4. Under “Formatting style”, click the strikethrough button (the S with a line through it). We also set the text color to gray, so finished tasks fade into the background.
  5. Click Done.

In our list, the two ticked tasks were crossed out and grayed across all five columns, and the three open tasks stayed as they were.

=$B2 works on its own because a checkbox already holds TRUE or FALSE. =$B2=TRUE does exactly the same and is a little more explicit; use whichever you find clearer.

If the strikethrough lands on the wrong cells

The formula is written for the first row of the range and Google Sheets moves it down row by row. Three slips break that, and none of them shows an error:

  • No dollar sign before B (=B2). The column then moves along with each cell, so only the first column of the row follows the checkbox. In our test with a fill color, only column A changed.
  • A dollar sign before the row too (=$B$2). Every row then follows the first checkbox, so ticking one task crossed out the whole list in our test.
  • The wrong row number. If the range starts at row 2, the formula must say $B2. With $B3, each row followed the box of the row below it.

Our guide to changing row color with a checkbox shows each of these mistakes side by side.

Found in testing: you can use strikethrough and a fill color in the same rule, but if you want different looks for different cases, such as crossed out when done and orange when late, use two rules. When both are true, the rule listed first decides the format, so put “done” first if finished tasks should never look late.

Cross out only the task name

To strike through just the text in column A and leave the dates and amounts readable, set “Apply to range” to A2:A100 and keep the same formula, =$B2. The dollar sign still points every row at its own checkbox in column B.

Related guides