Breaking News: Grepper is joining You.com. Read the official announcement!

gsheet get cell background color

Long Lion answered on October 15, 2021 Popularity 3/10 Helpfulness 3/10

answer gsheet get cell background color

gsheet get cell background color

Comment

/**
 * Returns the Hexadecimal value of a cell's background color.
 *
 * @param {number} row The cell's row number.
 * @param {number} column The cell's column number.
 * @return The Hexadecimal value of the cell's background color.
 * @customfunction
 */
function BGHEX(row, column) {
  var background = SpreadsheetApp.getActive().getDataRange().getCell(row, column).getBackground();
  return background;
}

Popularity 3/10 Helpfulness 3/10 Language javascript

Source: spreadsheet.dev

Tags: background-color cell get javascript

Link to this answer
Share Copy Link

Contributed on Oct 15 2021

Long Lion

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

gsheet get cell background color

Contents

More Related Answers

gsheet get cell background color

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.