Importing the colored value from a range

[shazzad.arla]

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?

 

[Ralston18]

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.