Conditional Formatting in Matrix

[kaushikd]

I have dataset like below:-

Col A	Col B	Value	Color
A	a	1	RED
A	c	2
B	b	3	RED
C	c	2	RED
D	a	5	Green
D	c	6
E	b	4	Green
F	a	1
F	c	3	Green
G	b	6

I need the output like this:-

Is there any work around to achieve this. Color Code will be assigned to the group as like (A,a), (B,b) and (C,c) and of RED groups and as per the groups the color should come into the Matrix, it should not be dependent on value. Is there any work around of achieving this may be not exactly but any alternative.

[v-jiascu-msft]

Hi @kaushikd,

I would suggest you create an idea here.

Best Regards,

Dale

[kaushikd]

Hi @v-jiascu-msft,

Thanks but I need any work around if possible.

[kaushikd]

@Greg_Deckler

@Phil_Seamark

@ravalib

Guys please help need some idea on this, any alternative solution.

[Greg_Deckler]

Only thing I can think of is an image underlay with transparency on your matrix. Ugh.