serhii.net

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.
comments powered by Disqus