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?
Google-sheets – Formatting Cells in Google Sheets
conditional formattinggoogle sheets
Related Topic
- Google-sheets – Conditional Formatting in GSheets
- Google-sheets – Conditional Formatting using Google Sheets
- Google-sheets – Format cell if all the cells in a row are not empty
- Google Sheets – Conditional Formatting Guide
- Google-sheets – Conditional Formatting IF/AND Google Sheets
- Google-sheets – google sheets checkbox conditional formatting
- Google Sheets – Conditional Formatting for Last 24 Hours
- Google-sheets – Google Sheets – Highlighting Cells if they contain text from another range of cells
Best Answer
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).