Hi all,
really difficult one here.
I have a risk mairx i need to program into excel
i want to use conditonal formatting to specify the colour of the cell but it is difficult
for eg
on the risk matirx there are two things likelhood and impact
tp find out the risk score you multply the likelhood value by the impact value
maxium values both can have is 5 On the matrix the sum of these two values correspond to a colour on the matrix
but the problem is that two products can be the same colour
see attachment jpg
how do i program this into excel so when
i input the likelhood score in one cell and the impact score in another cell
it gives e the correct product and colours the cell with the correct colour that corresponds to the matrix
IS IT IMPOSSIBLE!!!!