Conditional formatting: If checkbox ticked in cell A1, change color/strikethrough of cells from B1-F1.
Insert a checkbox from "Insert" tab to A1.
Select the cells (B1-F1) that needs to be of different color/strikethrough when a checkbox in A1 is ticked/ selected.
From tab above, "Format" > "Conditional formatting".
In 'Single color' tab, "Apply to range" = 'B1:F1'
"Format cells if" = 'Custom formula is' = '=$A1=TRUE'
"Formatting style" = Select whatever change you want to see in the cells if checkbox ticked.
DONE !!!
Answer from sreejith r on Stack ExchangeConditional formatting: If checkbox ticked in cell A1, change color/strikethrough of cells from B1-F1.
Insert a checkbox from "Insert" tab to A1.
Select the cells (B1-F1) that needs to be of different color/strikethrough when a checkbox in A1 is ticked/ selected.
From tab above, "Format" > "Conditional formatting".
In 'Single color' tab, "Apply to range" = 'B1:F1'
"Format cells if" = 'Custom formula is' = '=$A1=TRUE'
"Formatting style" = Select whatever change you want to see in the cells if checkbox ticked.
DONE !!!
Assuming (1) your checkbox is character ☑ (Code 9745) and your entire row runs to ColumnZ, then please select ColumnsB:Z and apply a Custom formula is of:
=$A1="☑"
with formatting of Strike-through and Done.
I used the To Do List template to make a checklist. When the checkbox is checked the item on the list has strikethrough text. I like that.
I have added a second checkbox column to my list. I would like the text to only strikethrough if both checkboxes are checked.
Example:
On my list, my columns are labeled N | S | Item
Only if the N and S are both checked, would I like the Item text to be Strikethrough. I can not figure out the formula for this.
Any guidance on this would be helpful as I am not finding any help through google on the double-check.
Thanks
Hi! I am trying to format where with a checkbox, it will strikethrough on the next cell. I had it working, but now it is not. I used, "=$B$23=TRUE" and then changed the format to strikethrough. It stopped working. Can someone help. I am trying to do it for the calendar and the to-do list.
Link: https://docs.google.com/spreadsheets/d/1uvswiwEasQ7ZyQwdyEp6Ux3fFMihipYmb4GjWSdUjUc/edit?usp=sharing
https://imgur.com/a/PiTsyfE
I am pretty much trying to cross out D3 and E3-E7 when the checkbox on the left is clicked. Is there a way to do this? I've only been able to cross out D3 or E3 so far.
Thanks!
I have a sheet that I use to track quests in my D&D game. When I check the checkbox for a quest I would like it to strikethrough the rest of the row. I am also using custom cell values for the checkboxes as Completed and Incomplete instead of False and True. Can someone please help me with this? I have linked a copy of my sheet below.
Sheet: https://docs.google.com/spreadsheets/d/1AK-vOVDufvrzKls7xq5Zte9uaRPWXUApsAaXHma56bc/edit?usp=sharing