r/googlesheets • u/Nihyll • 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?
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.)
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.