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!
Would you like to learn more about Risk Management?
Get instant access to our online Risk Management course on ISO 14971:2019 right here. In 6 hours, you can learn more about how to estimate risk and perform risk management. This course is taken by both competent authorities, notified bodies and medical device manufacturers and distributors.
Peter Sebelius (PMP) is a highly esteemed trainer, consultant and entrepreneur in the medical device industry. He is a member of the Joint Working Group that is revising the ISO 13485 and ISO 14971 standards.
He has vast ‘hands on’ experience too, having developed, amongst other things, a mechanical chest compression and an ex vivo perfusion machine for lungs. He has received numerous awards including the Great Design Award and the title “This year’s specialist” by Veckans affärer.