Add Conditional Formatting Rules to a Google Sheet Tab with Apps Script

Описание: Adding new conditional formatting rules to a Google Sheet tab with Apps Script can be tricky. This tutorial covers how to do this without deleting the existing conditional formatting in the sheet tab.

To the Starter Sheet!: https://docs.google.com/spreadsheets/...

The Conditional Formatting with Apps Script Playlist:

   • Apps Script - Conditional Formatting  


00:00 What we're building
00:14 What we need to test for.
02:14 The starter script and Test function
01:38 A look at the starter code and test code
07:58 Creating the function
13:48 Test our script

** My Site **
https://yagisanatode.com/

** More on Google Apps Script **
https://yagisanatode.com/google-apps-...

** Products **
Courses *
https://yagisanatode.com/products-cat...

Google Workspace Tools *
https://yagisanatode.com/products-cat...

Google Workspace Add-ons *
https://yagisanatode.com/products-cat...

#GoogleSheets #googleworkspace #GoogleAppsScript #AppsScript #businessautomation #businessadministration