Stack Exchange! Today I wish to use Google Sheets' conditional formatting option "text starts with" to blur out a range of cells (by changing color of text and background). That is the easy part which I know. The hard part which I'm asking about is the checkbox. How can I code the conditional formatting to apply IF checkbox = true AND text starts with "X"?

Here is a link to a demo sheet which simplifies the task at hand. https://docs.google.com/spreadsheets/d/17f8vUkfT_kJR0F7NwWIAZK-RCchTg09yXj_dhfSbBz8/edit?usp=sharing

enter image description here

  • Where is the text that you want to format conditionally? Please show your manually entered desired results, for example in the scenario where A, B, C and E are checked and D is unchecked. Jan 7, 2023 at 9:34

1 Answer 1


Try the file at this link that use this formula for the custom formatting of range B7:F11



  • I tried your formula which at first glance works. But when I unchecked the A column of data, the formula which creates the table shifted up and left. Thus resulting with your conditional formatting applying to the wrong column.
    – Ylahris
    Jan 7, 2023 at 14:19
  • You did bring to my attention the "left" function. I'll see if I can code something which solves my problem.
    – Ylahris
    Jan 7, 2023 at 14:27
  • In the real sheet (not the demo sheet), I applied the 'left' function you brought my attention to and was able to write =if((and($B$13=false, if(left(C19,1)="ʔ",true,false))),true).
    – Ylahris
    Jan 7, 2023 at 14:43

Your Answer

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

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