CODEWITHSUNDEEP
google-sheetsconditional-formatting
Yesterdec
Yesterdec

Reputation: 47

Paste conditional formatting when conditional formatting formula is absolute

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).

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?

Upvotes: 0

Views: 72

Answers (1)

teylyn
teylyn

Reputation: 35970

Drop the $ sign in front of the row, so the row number becomes relative.

=$J1=TRUE

When copied to row 2 it will then refer to row 2, etc.

Upvotes: 1

Related Questions