When I check the box within the checklist template in Numbers I want the entire row to have a strikethrough. How is this accomplished within Numbers?
select the cell(s) then use the cell text formatter:
See the bottom right of the image in this post to see strike through segment in the character styles
Thanks but what I'm looking for is when I click the Yes/No box within my checklist within Numbers, I want the entire row to automatically receive a strikethrough. I want cells "B2" through..... to receive a strikethrough based on the action within Cell A2.
You are looking for a way to apply a specific 'highlighting' format to certain cells, depending on the content on one cell.
This is called 'conditional highlighting' and is controlled by applying a 'conditional highlighting rule' to each of the cells to be highlighted.
CH rules compare the content of the cell to be highlighted to a fixed value, written into the rule, or to the value in another cell, whose location is included in the rule.
In your case, the 'highlight' (strikethrough) is to be applied to the text displayed in the cell, and the control is to be the state of a checkbox cel in the same row.
The four cells to be highlighted can contain any text (column B) or any number (columns C, D and E). The 'control' cell in column A can contain only two different values— TRUE or FALSE. Clearly, a direct comparison between the content of the cells to be formatted and the control will not provide a "TRUE" result when the control cell was checked and a "FALSE" result when it was unchecked (or vice versa) depending on whether the box was checked or unchecked,
Enter a 'helper' table.
Each cell in columns B through E of CH helper contains an IF formula that copies the content of its 'sister' cell on the CHECKLIST table IF the box in column A is checked, and returns a null string ( "" ) if the box is unchecked.
The Conditional Highlighting rule shown to the right of the tables compares the values in a cell on CHECKLIST with the same cell on CH helper. If the content, read as text, is the same in both, the conditional highlight (Strikethrough) is applied to the visible text in the cell; otherwise, the 'normal' format assigned to he cell and its content is applied.
Results are as shown.
Formula in CH helper::B2: IF(Checklist::$A2,Checklist::B2,"")
Fill right to the last column in the table, Fill down to the last row of the table.
The table must contain at lease as many rows and columns as the CHECKLIST table. EXTRA rows or columns will show error triangles.
Setting the CH Rule:
Select all cells from B1 to the last row of column E.
In the Format Inspector, choose Cell, then click Conditional Highlighting (at the bottom of the Inspector pane).
Click Add a Rule, then choose Text, then choose 'is"
Click the icon at the right end of the box under "text is", then click cell B1 on CH Helper.
In the box that says "red text", click the triangle, scroll to the bottom of the list and choose Custom Style.
Click B to turn off bold, then click the S (with a strikethrough line) to apply Strikethrough.
Click Done at the top right of the inspector panel.
The SH helper table may be hidden on another Sheet, or by placing it behind an opaque object.
Regards,
Barry
creating a strikethrough on a row within a checklist
