I'm dealing with this problem in the last couple of days.
I have formatted with Conditional formatting two color matrices 52x24 cells in two different sheets and both sheets (matrix results) are linked to the first numerical data base sheet.
What I want is to generate the third matrix which is a mix (merge) of previously defined 2 matrices, and it should be defined by the combination of their colors (regardless the numerical content)
For example: if the cell A1 sheet1 is RED and the cell A1 sheet2 is YELLOW then the cell A1 on the sheet3 is BLUE; or if the cell A1 sheet1/sheet2 is GREEN, the cell A1 sheet3 is GREEN too and so on, using 12 colors to generate the 3rd matrix with the final result, based on the color combination rules.
Is there any simple or a complex way in solving this issue? What I'm trying is to define a formula in the 3rd matrix conditional format rules but I'm not sure if it is a good approach.
Thanks in advance for your help and your time.
I have formatted with Conditional formatting two color matrices 52x24 cells in two different sheets and both sheets (matrix results) are linked to the first numerical data base sheet.
What I want is to generate the third matrix which is a mix (merge) of previously defined 2 matrices, and it should be defined by the combination of their colors (regardless the numerical content)
For example: if the cell A1 sheet1 is RED and the cell A1 sheet2 is YELLOW then the cell A1 on the sheet3 is BLUE; or if the cell A1 sheet1/sheet2 is GREEN, the cell A1 sheet3 is GREEN too and so on, using 12 colors to generate the 3rd matrix with the final result, based on the color combination rules.
Is there any simple or a complex way in solving this issue? What I'm trying is to define a formula in the 3rd matrix conditional format rules but I'm not sure if it is a good approach.
Thanks in advance for your help and your time.
