Skip to content

Instantly share code, notes, and snippets.

@oyakudachi

oyakudachi/if else text.js

Last active August 16, 2018 04:57
Show Gist options
  • Save oyakudachi/889a8ebf40002609b1276b087e959ff7 to your computer and use it in GitHub Desktop.
Save oyakudachi/889a8ebf40002609b1276b087e959ff7 to your computer and use it in GitHub Desktop.
Download ZIP
Google apps script
Raw
if else text.js
if(rng[i]=="赤テキスト"){
sht.getRange(i+4,4).setValue('赤文字').setHorizontalAlignment("center").setFontColor("red");
}else if(rng[i]=="赤テキスト黄色塗り"){
sht.getRange(i+4,4).setValue('赤＆黄色').setHorizontalAlignment("center").setFontColor("red").setBackground(color);
}else{
sht.getRange(i+4,4).setValue('青文字').setHorizontalAlignment("center").setFontColor("blue");
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment