A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets

An easy to use pseudo-class to quickly set and clear conditional formatting rules in a Google Sheet tab with Apps Script.

The key methods:
- clearRule - You can clear a range of rules by:
1. And exact range match.
2. Any rule within a target range.
3. Any rule overlapping a target range.
- setRule - Set conditional formatting rules and position them in your desired order.

To the documentation! https://yagisanatode.com/clear-and-set-conditional-formatting-rules-to-a-specific-range-in-google-sheets-with-apps-script/

The Conditional Formatting with Apps Script Playlist:

https://www.youtube.com/playlist?list=PLSDEbLgMgqvqETwEGcHZQfMZJVP-Fh7K-

00:00 Intro
00:47 Range_ConditionalFormatting(sheet)
01:17 clearRule method
02:02 clearRule(ranges) – Ranges and no optional clear type
05:18 clearRule(ranges, 0) - Exact match
06:16 clearRule(ranges, 1) - Within range
08:47 clearRule(ranges, 2) - Overlapping ranges
10:58 setRule method
13:13 setRule(rules) - rules array with no position param
14:12 setRule(rules, -1) - Position bottom
15:18 setRule(rules, 0) - Position top
16:22 setRule(rules, -6) - 6 places up from bottom.

** 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

Видео A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets канала Yagisanatode -Scott-