Foreground color of a text in a cell
Solution 1:
Try
function FCOLOR(input) {
return SpreadsheetApp.getActive().getRange(input).getFontColors();
}
and in the spreadsheet pass the range as a string. E.g:
=FCOLOR("A2:A4")
Foreground color of a text in a cell
Solution 1:
Try
function FCOLOR(input) {
return SpreadsheetApp.getActive().getRange(input).getFontColors();
}
and in the spreadsheet pass the range as a string. E.g:
=FCOLOR("A2:A4")