8

I have a Google Sheets. I want to set it up so that the first column is checkboxes, and if the checkbox is selected, the entire row gets a strike-through.

How can I accomplish this?

I followed this to add checkboxes, but now I need the row to strike-through if the check box is checked. For example:

Check box Phone number Name

no check xxxxxxxxxx John Doe

Check xxxxxxxxxx Jane Doe

In other words, if a1 = ☑, then strike-through all of Row A.

How do I apply this to the entire sheet?

  • Yeah I know that much... but I'm not able to get it to work. For example just testing it out on one row. I select the range I would like the strikethrough to apply to, then I select Custom Formula =$A1="☑", then the formatting I apply is strikethrough. When I go to A1 and input ☑, I get no formatting. – GiH Oct 7 '17 at 23:08
2

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.

  • 1
    I just realized what I was doing wrong, I was using A1 when it was A2... haha – GiH Oct 9 '17 at 0:00
  • Now the question is, since its working on one row, how do I apply this to every row? I can't use =$A2="☑" because it will only apply to row 2, how can i setup the conditional formatting for the entire document to say if your row in column A contains ☑, then format your row? – GiH Oct 9 '17 at 0:06
  • But in this example it all depends on A1, so basically row 4 will strikethrough only if a1 is checked, but row 4 should only strikethrough if A4 is checked, and shouldn't be connected to A1 at all. – GiH Oct 9 '17 at 0:58
  • Its not working though, and the logic says (as I understand it) for the range B2:Z2 (since we are in row 2), check if A1 is checked, and if it is strikethrough. If I set A3 to checked, why would it format anything? Are you saying that I have to apply the formatting to every single row? and change the custom formula for each to the row number we're in? – GiH Oct 9 '17 at 16:30
3

Conditional formatting: If checkbox ticked in cell A1, change color/strikethrough of cells from B1-F1.

  1. Insert a checkbox from "Insert" tab to A1.

  2. Select the cells (B1-F1) that needs to be of different color/strikethrough when a checkbox in A1 is ticked/ selected.

  3. From tab above, "Format" > "Conditional formatting".

  4. In 'Single color' tab, "Apply to range" = 'B1:F1'

  5. "Format cells if" = 'Custom formula is' = '=$A1=TRUE'

  6. "Formatting style" = Select whatever change you want to see in the cells if checkbox ticked.

DONE !!!

2

Based on the answer from Rubén, I stumbled into a way to do it across the whole spreadsheet. It worked for me as follow:

screen shot

  1. Insert a checkbox from "Insert" tab to H1 (in my case)
  2. From tab above, "Format" > "Conditional formatting".
  3. In 'Single color' tab, "Apply to range" = 'A1:H1032'
  4. "Format cells if" = 'Custom formula is' = '=$H1=TRUE'
  5. "Formatting style" = Select whatever change you want to see in the cells if checkbox ticked.

For any checkbox that I tick, it will now apply the formatting style to that given row only.

  • Should be correct answer. – Avi Parshan May 17 at 8:34
0

You can also do a: "Text Contains: TRUE" or "Text Contains: FALSE" check here.

0

It's also interesting to note that you must include the $ symbol in order to get multi-column coverage. To me, it seems a slightly counterintuitive.

Difference

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.