Google SpreadSheets get cell color

Question

I wasted a whole day on this and still haven't solved it. How the hell do I create a function that returns the background color of a specified cell? How to get the range of the function's argument, and then its background color? This is what I tried:

/**
 * Returns the Hexadecimal value of a cell's background color.
 * @param {cel} input The cell to get color.
 * @customfunction
 */
function getColor(cel) {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(cel);
  var background = ss.getBackground();
  return background;
 
}

Answer 1

The function you use is set-up as a custom function

• This means that it can be called from the spreadsheet and returns a value to the cell from which it is called.

• To call it you need to type into a cell preceeded by a = and with a range notation in quotes passed as funciton parameter.

Sample call:

=getColor("F2")

Answer 2

In case someone come back to this question, the initial code is correct, but it need to be called with the address of the cell.

Example:

=BACKGROUND_COLOR(cell("address"; A1))

Answer 3

Good morning attached proposal put A1 in quotation marks "A1"

function myBackgroundRanges(myRange,myTigger) {  
  return SpreadsheetApp.getActiveSpreadsheet()
          .getActiveSheet()
            .getRange(myRange)
              .getBackgrounds();}

Ejemplos