Hi,
In worksheet 1 I have a 5x5 matrix that includes repeat values with different colours, depending on the Impact and Likelihood.
E.g. L*L(2*2) = 4(Green), VL*H(1*4) = 4(Yellow) and vice-versa H*VL(4*1)(Yellow)
In worksheet 2 I have a form that has drop down lists to select the Impact and Likelihood VL,L,M,H,VH (for both Impact and Likelihood), and then uses INDEX MATCH to return the result from the matrix. Formula
I'd like to have the cell colour where the above formula for I*L on Worksheet 2 change, depending on the "4" value. As it can depend on the I and L. As a score of 4 can be either green or yellow.
Many thanks
Jm,
In worksheet 1 I have a 5x5 matrix that includes repeat values with different colours, depending on the Impact and Likelihood.
E.g. L*L(2*2) = 4(Green), VL*H(1*4) = 4(Yellow) and vice-versa H*VL(4*1)(Yellow)
In worksheet 2 I have a form that has drop down lists to select the Impact and Likelihood VL,L,M,H,VH (for both Impact and Likelihood), and then uses INDEX MATCH to return the result from the matrix. Formula
Excel Formula:
=IFERROR(INDEX('Risk Matrix & Impact Tables'!$C$4:$G$8,MATCH(K3,Likelihood,0),MATCH(L3,Impact,0)),"0")
I'd like to have the cell colour where the above formula for I*L on Worksheet 2 change, depending on the "4" value. As it can depend on the I and L. As a score of 4 can be either green or yellow.
Many thanks
Jm,