check and strike

Check Off and Strikethrough a Name

I was asked if it is possible to have a list item strike out in a Google Sheets spreadsheet when a checkbox is checked. Yes you can.

Google Sheets online workshop

Insert Checkboxes

In a spreadsheet highlight a range of cells or click on the column indicator and use the Insert menu to choose “Checkboxes.”

check and strike
For a sample spreadsheet click here.

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.”

check and strike



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

check and strike

Try it Out

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




k



Subscribe to the Alice Keeler Newsletter

Subscribe

alicekeeler.com/newsletter

WP Twitter Auto Publish Powered By : XYZScripts.com
%d bloggers like this: