Importing the colored value from a range

Mar 13, 2018
1
0
10
0
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

Dignified
Moderator
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.
 

Ralston18

Dignified
Moderator
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.
 
Thread starter Similar threads Forum Replies Date
J Apps General Discussion 1
A Apps General Discussion 1
B Apps General Discussion 1
C Apps General Discussion 4
A Apps General Discussion 12
J Apps General Discussion 2
S Apps General Discussion 2
K Apps General Discussion 2
S Apps General Discussion 6
P Apps General Discussion 7
XAKEP Apps General Discussion 1
E Apps General Discussion 1
Y Apps General Discussion 1
C Apps General Discussion 1
S Apps General Discussion 5
THRobinson Apps General Discussion 1
P Apps General Discussion 1
I Apps General Discussion 9
R Apps General Discussion 0
A Apps General Discussion 0

ASK THE COMMUNITY