How to mix / merge colors of 2 Conditional formatted matrices?

[coniconi]

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.

Capture.JPG

[Pauleyb]

Recommend you continue with conditional formatting. It is a pain in the neck for all 32 combinations you mention, but it is simple.

For example, if sheet1 rule for red is A1>300 and sheet2 rule for yellow is AND(A1<55, A1> 30), then the equation for sheet3 blue would be and(sheet1!A1>300, sheet2!A1<55, sheet2!A1>30)

[coniconi]

Thank you very much for your answer.
I had just a wrong approach thinking in a more complex way. In fact, I just need to continue combining rules, as you mentioned, and for this "normal" size of matrices it will work perfectly.
Thank you for your time and help, and all the best !