Answers for "excel sheet cell color formula"

2

excel sheet cell color formula

//create this function on a script on sheets
function GetCellColorCode(input) 
{ 
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  var cell = ss.getRange(input); 
  var result = cell.getBackground(); 
  return result 
}

...

// then use this code inside cell
=GetCellColorCode("A"&ROW())

...

// result will be the color in hex
> #fffff
Posted by: Guest on January-13-2021

Code answers related to "excel sheet cell color formula"

Browse Popular Code Answers by Language