In the middle of the desert you can say anything you want

29 May 2023

Google spreadsheets basics and conditional formatting

How To Apply Conditional Formatting Across An Entire Row;

  • Basics
    • $A$1 is a direct reference to A1, that won’t move if formula is applied to a range
    • ISBLANK(..) means cell is empty
    • AND(c1,c2,...,cN), OR(c1,c2,...,cN)
  • Cond. formatting bits
    • If you need to pick the “current” cell, it’s the first cell of the range without $s
    • =$U1=1 is “if U of the current row is equal to 1” (then you can color the entire row green or whatever)
    • The order of the rules is precedence, that is rule N will overwrite N+1
Nel mezzo del deserto posso dire tutto quello che voglio.