Quote Originally Posted by Zaxest View Post
Such as if the matrix changed like if a likelihood and impact was changed to result in a different risk rating.


For example if "Rare" likelihood and "Insignificant" impact will now return the risk rating of "Low" but if suddenly I need to have it return a risk rating of "Medium".
No changes to the code would be required for that or for colour changes.
Quote Originally Posted by Zaxest View Post
Also is the formula "Vlookup" possible to be implemented in word for a risk assessment document like this or is macro the best way to go?
Word has no lookup functions of any kind.