I have list boxes in the Likelihood of a risk in one column:
Remote - green
Average - yellow
Certain - red

In Severity of risk in column two:
Minor - green
Moderate - yellow
Critical - red

The third column I'd like the overall risk color to autofill based on the choices of column one and two:

Please Login or Register  to view this content.

I'm not sure where to write the code for it to make sense - a Macro or VB? I'm used to Access so converting it in my mind has me stumped.