combinations_fillcolor_brown

[vba_life]

hi i have attached an excel sheet for a clear demonstration.

Below are the combinations :-

1.So example go to the Investments column and the corresponding Revenues Row then that particular cell should be filled in brown color.(this is cell M22 with value 0)

similarly

2.Go to next combination that is Inventiories column and the corresponding Revenues Row then that particular cell should be filled in brown color.(this is cell L22 with value 18)


I have done them manaully coloured for some of the combinations.

I need it either in the form of a macro or condtional formatting.


please help me with the easiest way.

Thank You.