Is there some sort of conditional formating I could use to do this?

I would like the checkbox in col A to trigger strikeout in col B,C,D but stop before the next name in column B.

I am able to set the checkbox to strikeout multiple lines with conditional formatting, but with the number of lines changing with every name, this is not a viable option.

I used =$A1=TRUE for the range I want strikeout, but this would mean I need to apply this everytime I have a different number of rows with a new range?

enter image description here

  • Welcome to Web Applications. Please show what you tried and add a brief description of your search efforts as is suggested in How to Ask.
    – Rubén
    Feb 8 at 2:55
  • Done! Thank you for the guidance!
    – Sheetster
    Feb 8 at 3:52

1 Answer 1


You could do it with this formula. Try it and let me know:


It looks up the previous non empty cell in B and with INDEX it checks the value of column A:

enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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