Thank You @selimovd for your help. The simple conditional formatting of background is not allowing me to change the colors of the cells on the basis on the row and column header values. Example:
The cells corresponding to a,b,c,d segment for both row and column need to have yellow colour and the cells to the right of yellow colour shading should be green and the cells to the left should be red.
What it is allowing me to do is change the colors on the basis of the values.
Is there any way I can make the cells take the desired colour on the basis of values of the column and row header? Like yellow when both row and column header are same, it will go yellow
Green when row header is a and column header is b,c,d.
Red when row header is c and column header is a,b.
Thank you again for your help.
Looking forward to your reply.
Best,
Rahul
