how to add strikethroughs in google sheets
IN SUMMARY
To add strikethroughs to text in Google Sheets, you can use conditional formatting with a custom formula. When a checkbox is checked, the corresponding text will be struck through and optionally change color or background.
Setting Up Checkboxes
Select the cells where you want to add checkboxes, then go to Insert > Check Box. This will insert a checkbox in each selected cell.
To quickly add checkboxes to multiple cells, you can copy and paste the first checkbox or drag the blue square in the bottom-right corner of the selected cell to fill the desired range.
If you have multiple lists that need different formatting, you can separate them into different ranges. This allows you to apply conditional formatting rules independently for each list.
Applying Conditional Formatting
Go to Format > Conditional Formatting, then click on the 'Add New Rule' option at the bottom of the list. This will open the conditional formatting rules editor.
In the 'Format Rules' section, select 'Custom Formula Is'. In the formula box, enter '=$A1=TRUE' (replace A1 with the cell reference of your first checkbox). This formula checks if the checkbox is checked (TRUE).
With the custom formula set, you can now customize the formatting for checked checkboxes. Click on the 'Formatting Style' options to add strikethroughs, change text color, or set a background fill color for checked items.
Advanced Options
You can create multiple conditional formatting rules for different formatting options. For example, one rule for strikethroughs and another for text color changes.
If you need to automate tasks related to strikethroughs or conditional formatting, you can use Mage AI's =AI() functions in Google Sheets. Visit usemage.com to learn more.
Strikethroughs can be combined with other formatting options like bold, italics, or underlines for added emphasis or organization in your to-do lists or task tracking sheets.