Hello,

I have three columns (A,B,C) in total. The first column A contains codes, for example A01, 110, 200, etc. The second and third columns B and C contain cells that are filled either by green, yellow, or red color.
Now if columns B and C are, for example, both red, then I want to know which codes from column A are associated with this color combination. For all the other color combinations (red&green, red&yellow, yellow&green, yellow&yellow, green&red, green&yellow, green&green), I also want to know which codes from column A are associated with these colors and print the results.
Can somebody help please?

Thanks in advance.