Answers for "excel sheet cell color formula"

Whatever

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

Source

Code answers related to "excel sheet cell color formula"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#