Clear Conditional Formatting Rules by Exact Match in Google Sheets with Apps Script
Scott Yagisanatode
Remove a conditional formatting rule by the exact range in Google Sheets with Google Apps Script.
To the Starter Sheet!: https://docs.google.com/spreadsheets/d/1snkQPSNCZvVhRSmhQMiUeB3Hh6q8SDZcaD8JxqOxk1M/copy
The Conditional Formatting with Apps Script Playlist: https://www.youtube.com/playlist?list=PLSDEbLgMgqvqETwEGcHZQfMZJVP-Fh7K-
00:00 Intro 00:51 What we're building 01:23 The starter script and Test function 02:48 Check if range is array or object 05:27 Get ranges as A1 Notation 06:16 Get current conditional formatting rules 07:58 Reduce iterator over current rules 09:39 Reduce iterate over rule ranges 14:11 Handle no more ranges in rule 15:22 Add remaining rules back to update_rules 18:28 Reset conditional formatting for sheet 18:53 Testing our script
** My Site ** https://yagisanatode.com/
** More on Google Apps Script ** https://yagisanatode.com/google-apps-script/
** Products **
Courses * https://yagisanatode.com/products-category/courses/
Google Workspace Tools * https://yagisanatode.com/products-category/google-workspace-tool/
Google Workspace Add-ons * https://yagisanatode.com/products-category/gwao/
#GoogleSheets #googleworkspace #GoogleAppsScript #AppsScript #businessautomation #businessadministration ... https://www.youtube.com/watch?v=kJoWhXyYzWQ
105259077 Bytes