How do I dial only colored cells in GAS?

There is a behavior that I used to do in Excel's VBA, but the spreadsheet has been changed and it has stopped working.
I've never used GAS, and I don't know how to reproduce what I've done so far...

It means that only cells with a fixed background color in column A ("yellow" in this case) are numbered.
On the VBA,

Dimc As Range, iAs Long
For Each c In Selection
    If c. Interior.ColorIndex=6 Then
        c=c+i+1
        i=i+1
    End if
Next c

Failed to manually select the cell range you want to search for and start the macro.

If anyone knows how to reproduce this behavior with GAS, please let me know.

google-apps-script

2022-09-30 21:31

1 Answers

The behavior can be reproduced by:

function myFunction(){
  varactiveSheet=SpreadsheetApp.getActiveSheet();
  range=activeSheet.getSelection().getActiveRange();
  varbgColors=range.getBackground();
  var values = range.getValues();
  var num = 1;
  for (vari in bgColors) {
    for(varjing bgColors[i]){
      if(bgColors[i][j]==="#ffff00")
        values[i][j] = num++;
    }
  }
  range.setValues(values);
}

2022-09-30 21:31

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656