Answer the question
In order to leave comments, you need to log in
Is it possible to take the color of a cell from another sheet?
Is it possible to take the color of a cell from another sheet?
There are 2 sheets.
The price from sheet #2 is displayed on the first sheet.
Sheet #2 contains the price and color of the supplier (cell with color).
In addition to the price that we take from the second sheet, we also need to take the color of the cell. Ideally, immediately paint the price on the first sheet in the color of the supplier.
Is it possible to do so? on the Internet, information is only on conditional formatting, but I can’t find if it’s possible to take a color from another sheet
Answer the question
In order to leave comments, you need to log in
As far as I know, there is no such functionality out of the box.
I would do this: I would make an area with color values. They can be obtained by a custom function in which to get colors using Range.getBackgrounds().
And set conditional formatting. It will turn out a bunch of rules, but it will work automatically.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question