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