I have the following sheet showing consequence, probability and the corresponding risk of an action.
- I would like to create a tool where the Consequence and Probability are drop down lists.
- I will like that in the Risk column, the corresponding risk is automatically displayed when I select a Consequence and Probability from the dropdown lists'
- Is it possible to change the colour of the risk cell to correspond to the risk of the event? E.g. a range of colours start from Green in the Very Low Risk to Red in the Very High Risk
| Consequence | Probability | Risk |
| Minor | Unlikely | Very Low Risk |
| Minor | Low Likelihood | Very Low Risk |
| Minor | Likely | Low Risk |
| Minor | High Likelihood | Low Risk |
| Mild | Unlikely | Very Low Risk |
| Mild | Low Likelihood | Low Risk |
| Mild | Likely | Low to Moderate Risk |
| Mild | High Likelihood | Moderate Risk |
| Medium | Unlikely | Low Risk |
| Medium | Low Likelihood | Low to Moderate Risk |
| Medium | Likely | Moderate Risk |
| Medium | High Likelihood | High Risk |
| Severe | Unlikely | Low to Moderate Risk |
| Severe | Low Likelihood | Moderate Risk |
| Severe | Likely | High Risk |
| Severe | High Likelihood | Very High Risk |
