Using MS Excel as a typewriting tool does work, but by implementing a few hacks, you can get so much more out of it, and most importantly, you can save time. In the video below I will show you how to let MS Excel colour your risk evaluation results automatically.
If you, like many others, colour code your risk evaluation results in your risk analysis, mistakes can easily happen. When you update the Probability of occurrence of harm or Severity and actually change the status of the risk from acceptable to unacceptable, the colour coding should follow. In another video we have made MS Excel fill in the risk evaluation matrix automatically, so you don’t have to worry about that, but what about the colour?
This video will show you how to colour cells using conditional formatting that will reduce the risk for mistakes in your risk analysis.
Remember that when implementing this functionality in MS Excel spreadsheets, you may be required to validate the spreadsheet.
If you want to try the function out for yourself, you can download a free hazard traceability matrix template that includes the formatting described in the video.
Let me know how it works in the comment field!