Adding background color to the selected cell in Google sheets by script

Question

All,

I am trying to make a timestamp sheet. The idea is whenever a user will press a button the selected cell will get the current time and background color will change to RED. I managed to fix the time part but not able to get it change color. The closest I got to it is :

function timeStampM() {
SpreadsheetApp.getActiveSheet()
    .getActiveCell()
   .setValue(new Date());

var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getDataRange();
var actCell = sheet.getActiveCell();
var actData = actCell.getValue();
var actRow = actCell.getRow();
if (actData != '' && actRow != 1)  //Leaving out empty and header rows
{
range.getRange(actRow, 2).setBackground('red');
}
}

This colors the cell in the 2 column of the selected cell rather than the cell itself. Any help will be hugely appreciated.

_Best Regards

It should be sheet.getRange(actRow, 2).setBackground('red'); inside the if block — Jack Brown
– Jack Brown, Commented May 17, 2017 at 13:53

OblongMedulla · Accepted Answer · 2017-05-18 16:57:49Z

4

this appears to work:

function timeStampM() {
SpreadsheetApp.getActiveSheet()
    .getActiveCell()
   .setValue(new Date());

var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getDataRange();
var actCell = sheet.getActiveCell();
var actData = actCell.getValue();
var actRow = actCell.getRow();
if (actData != '' && actRow != 1)  //Leaving out empty and header rows
{
actCell.setBackground('Red');
}
}

edited May 18, 2017 at 16:57

answered May 17, 2017 at 13:55

OblongMedulla

1,60110 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Jack Brown Over a year ago

I believe the question States that the code should change the background of column 2 of the selected row. Not the active cell itself.

OblongMedulla Over a year ago

Ahh, yes I missed that- I seen your answer above and have edited the above code.

Ayush Sharma Over a year ago

Thanks a lot guys, sorry if the question was confusing. I do aim to change the color of the selected cell and not the cell in 2nd column.

Ayush Sharma Over a year ago

@OblongMedulla : Your old code worked like a charm. Thanks a billion, if you edit your code back to the old one, I'll mark it as an answer. Cheers!

vesszabo Over a year ago

Error: { "message": "Script error.", "filename": "", "lineno": 0, "colno": 0 }

Collectives™ on Stack Overflow

Adding background color to the selected cell in Google sheets by script

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related