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.
Bookmarks