Introduction to how to fill cells with Office scripts.
The following syntax is used (Red letters indicate variable parts).
The color code is specified as a hex triplet (HEX). (Color picker)
workbook.getWorksheet("Sheet name").getRange("Cell address").getFormat().getFill().setColor("Color code");
For those who want to learn Office script effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.