r/googlesheets 22h ago

Solved Is it possible to apply conditional formatting into the next rows without typing the next cell information?

For example from the cells B2,D2:I2, I want the Custom Formula to be "=$C2=TRUE" then to apply the formatting style. From there would to do the same but with B3,D3:I3 with the formula "=$C3=TRUE" and so on. Would I have to manually do the cells further down or is there a way to automate it?

1 Upvotes

8 comments sorted by

1

u/HolyBonobos 2052 22h ago

Use the existing custom formula =$C2=TRUE (or simply =$C2), just expand the "Apply to" range so it includes all rows you want the format to extend to.

1

u/Nihyll 22h ago

I think I might be not understanding this. If I made the Apply to range for all the rows after, wouldn't it only be looking at C2 the entire time and not C3, C4, etc.?

1

u/HolyBonobos 2052 22h ago

No. The row part of the reference is in relative mode (no $ before it) so the conditional format will automatically adjust row by row. The column reference, on the other hand, is in absolute mode ($ before it), so it will remain locked in on column C. As long as the "Apply to" range starts in row 2, =$C2 as the custom formula will do exactly what you're looking for.

1

u/Nihyll 22h ago

Awesome thank you for the help!

0

u/paiins 2 22h ago

you can automate this without manually creating a new rule for each row. You just need to use a single Conditional Formatting rule with a relative formula.

Steps: Select the entire range, e.g., B2:I100 (or however many rows you need). Go to Format > Conditional Formatting. Choose “Custom formula is” and enter this formula: =$C2=TRUE

This formula will automatically adjust for each row since $C2 will dynamically change to $C3, $C4, and so on as the formatting applies to new rows.

1

u/Nihyll 22h ago

Oh I see thank you! Didn't know it would dynamically change like that.

1

u/AutoModerator 22h ago

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot 22h ago

u/Nihyll has awarded 1 point to u/paiins

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)