google script editor sheets change cell colour based on text code example Example: google sheet script change text color myRange.setColor("black");