I am trying to format cells in a google sheet based on columns before it in the row. For example, I have check boxes in B1 and C1, if both of them are unchecked (false) I would like D1 to turn red; but only if 2 in a row are unchecked. So if B1 & C1 are unchecked, then D1 is red; but if B1 is checked and C1 is unchecked, I want D1 to still be white. Is there a formula for this?

  • Welcome to Web Applications. Please show what you tried and add a brief description of your search/research efforts as is suggested in How to Ask.
    – Rubén
    Jan 21, 2021 at 21:16

1 Answer 1


Applied to range D1 (or D1:D if you want the following custom CF formula to apply to the entire Column D):


Format as desired (i.e., red fill).

  • This worked - so simple... Thank you!! I was making it harder than it was.
    – Danielle H
    Jan 22, 2021 at 15:53
  • 1
    Glad to help simplify, Danielle. Would you take a moment now to mark my post as "Best Answer"? It doesn't earn me any free donuts. But it does alert the community at large that the issue has been resolved; and it helps future users more easily arrive at answers to their similar questions.
    – Erik Tyler
    Jan 22, 2021 at 15:59

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.