A
A
acerdragons2021-06-26 04:25:27
Google Sheets
acerdragons, 2021-06-26 04:25:27

How to determine or return cell color in Google Sheets?

There are: 2 sheets in one table.
Required: The cells have a color, number 1 and number 2, you need to display data from one sheet to another through "=IF", but which correspond to the parameters.
Question: How to determine, return, get the cell color to use it in the formula? Perhaps a formula, an addition from Google, or a crutch?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
rPman, 2021-06-26
@rPman

function BGHEX(cell) will return string #XXXXXX

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question