Top menu

Using MS Excel as a risk management tool: Risk evaluation result coloring

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 color your risk evaluation results automatically.
If you like many others color 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 color coding should follow. In a 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 color?

This video will show you how to color 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!

No comments yet.

Leave a Reply

Get access to my best product development and quality assurance tips and tricks

You’ll receive practical tips and advice from me, Peter Sebelius, on how best to approach medical device product development, risk management and quality assurance – and probably some hints on improving your running form too!