Importing the colored value from a range

Mar 13, 2018
1
0
10
I have a spreadsheet with two separate sheets. I need to import the colored value from a range of sheet to the column C of Sheet 2. In short, something like,

If Sheet1!A4=Sheet2!A3, Sheet2!C3=The colored value of the range Sheet1!(C7:AG7)

and

If Sheet1!A10=Sheet2!A4, Sheet2!C4=The colored value of the range Sheet1!(C13:AG13)

Here is a test sheet.

Any idea?
 
Solution
You need to be able to "Get" the cell colors and compare them.

E.g. the following links:

https://stackoverflow.com/questions/24382561/excel-formula-to-get-cell-color

https://www.extendoffice.com/documents/excel/4546-excel-determine-color-of-cell.html

However, as is discussed in the link the process/logic may be problematic.

Explore some of the suggestions and logic provided. Google/research for similar links.

As an option, you might be able to re-apply the original logic that determined the respective cells' colors to from the beginning.
You need to be able to "Get" the cell colors and compare them.

E.g. the following links:

https://stackoverflow.com/questions/24382561/excel-formula-to-get-cell-color

https://www.extendoffice.com/documents/excel/4546-excel-determine-color-of-cell.html

However, as is discussed in the link the process/logic may be problematic.

Explore some of the suggestions and logic provided. Google/research for similar links.

As an option, you might be able to re-apply the original logic that determined the respective cells' colors to from the beginning.
 
Solution