Insert Checkboxes

Highlight the List

Highlight the list you wish to cross out when the checkbox is checked. Right click and choose “Conditional formatting.”

Conditional Formatting

Change the default in the side panel from “Cell is not empty” to “Custom formula is.”

Custom Formula

This seems weird, but you will use TWO equals signs for your custom formula. You will start your custom formula with an equals sign and then write the expression you would normally write in a cell. The condition I want to check in my example is if the value in cell A2 is true. A checked checkbox has a value of true. A non-checked checkbox has a value of false.

=A2=True

Try it Out

That is it! Now when you checkbox the checkboxes in column A the values in column B will strikethrough.