function myFunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var sheet = ss.getActiveSheet()
  var range = "a1:a4"
  var data = sheet.getRange(range).getValues()
  var dataColour = sheet.getRange(range).getBackgrounds()
  var array = []
  
  for(var i = 0; i<data.length; i++){
    array = array.concat([data[i], dataColour[i]])
  }
  Logger.log(array)
}

function myFunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var sheet = ss.getActiveSheet()
  var range = "a1:a10"
  var data = sheet.getRange(range).getValues()
  var dataColour = sheet.getRange(range).getBackgrounds()
  var array = []
  var newArr = []
  var newArrColour = []
  
  
  for(var i = 0; i<data.length; i++){
    array = array.concat([[dataColour[i], data[i]]])
  }
  
  var sortArray = sort(array)
  
  for(i = 0; i<sortArray.length; i++){
    newArr = newArr.concat([sortArray[i][1]])
    newArrColour = newArrColour.concat([sortArray[i][0]])
  }
  
  range = "c1:c10"
  sheet.getRange(range).clear()
  sheet.getRange(range).setValues(newArr)
  sheet.getRange(range).setBackgrounds(newArrColour)
}

function sort(arr) {
  arr = arr.sort(function(a, b) {return (a[0] < b[0]) ? -1 : (a[0] > b[0]) ? 1 : 0 });
  return arr
}