Need help in creating Color Combination logic for Matrix report

Hi Shrek,

Thanks for your response but your solution will not fulfill our requirements

1)You have made all blank text box color to "Aqua",this is not required. All the blank text box are having different colors.

2)Table is dynamic, its data will increase further and we can',t hardcode the Risk I'd values like you have.For eg Risk I'd value :1  can be at any coordinates like (2,1)  or( 3,3) .Whatever combinations user selects from the application. Value will go in that place.

What our requirement is that colors are fixed for each coordinates for eg It is fixed that at (1,1) =Green, (1,2)= blue,  (1,3)=Red.

And we are getting this color  only when there is Risk _I'd in that text box,when no risk I'd is there ,no colors will come.