title: Paste conditional formatting when conditional formatting formula is absolute
body: <p>In Google Sheets, I have data in cells A1:I1. I have a checkbox in cell J1 which, when checked, highlights cells A1-I1 (I'm using the conditional formatting formula =$J$1=TRUE applied to range A1:I1).</p>
  <p>I tried removing the $ sign from the formula, but then only cell A1 gets highlighted when the checkbox is checked. But with the $ in the formula, I can't paste the conditional formatting so that the J2 checkbox highlights A2:I2, J3 does A3:I3 and so on. I have 1000 columns I would like to apply this pattern so. Is there any way to quickly replicate this formatting across the range?</p>